ftaco96
asked on
Quest SQL Navigator vs. SQL*Plus
Hi, I need to write up a justification for my group getting about 10 licenses for SQL Navigator Professional, I think at $1500 apiece. Right now, much of the group uses SQL Plus, but I've been trying out a copy of SQL Nav, and I love it. It's so darn expensive, though.
Can someone please help me think of good bullet points for going from SQL Plus to SQL Navigator? And for going from command line to GUI in general? And I can't just say "It'll increase productivity." I have to say how, without getting too technical, because the boss's boss is going to be reading this. And please don't try to dissuade me from scrapping SQL Plus. I have to write this justification up, so all I need is the pros.
This is kind of urgent, since I need to turn it in tomorrow late morning. Thanks already.
Can someone please help me think of good bullet points for going from SQL Plus to SQL Navigator? And for going from command line to GUI in general? And I can't just say "It'll increase productivity." I have to say how, without getting too technical, because the boss's boss is going to be reading this. And please don't try to dissuade me from scrapping SQL Plus. I have to write this justification up, so all I need is the pros.
This is kind of urgent, since I need to turn it in tomorrow late morning. Thanks already.
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
that's like the old debate between command-line tool and windows-based tool (or gui-based tool).
that's really endless...
but i think you can rebut with....
SQL navigator with the ability to drag-and-drop SQL code DOESNOT simply means copy and paste.
It's the ease and simplicity of having Object (table) structure on the side, and building your query by dragging the tables and columns into the sql query builder...
So it's not like copy and paste codes around in which case, you have to write manually the code from the scratch.
Another benefit, SQL navigator with better debugging capability, it's highlighting syntax errors, better pinpointing the compilation errors (sqlplus can be misleading in locating the real errors). it's true you can do all the tunning in sqlplus command line, but developers needs formal training in how to use explain plan, autotrace, TKPROF , STATSPACK tools, which also cost money.
that's really endless...
but i think you can rebut with....
SQL navigator with the ability to drag-and-drop SQL code DOESNOT simply means copy and paste.
It's the ease and simplicity of having Object (table) structure on the side, and building your query by dragging the tables and columns into the sql query builder...
So it's not like copy and paste codes around in which case, you have to write manually the code from the scratch.
Another benefit, SQL navigator with better debugging capability, it's highlighting syntax errors, better pinpointing the compilation errors (sqlplus can be misleading in locating the real errors). it's true you can do all the tunning in sqlplus command line, but developers needs formal training in how to use explain plan, autotrace, TKPROF , STATSPACK tools, which also cost money.
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
Thanks seazodiac! I used many of your suggestions, and it looks like we're getting the funding for a few licenses. I did investigate PL/SQL Developer, but it's not company approved, so we're going with SQL Navigator.
Thanks for all your input.
Thanks for all your input.
ASKER
https://www.experts-exchange.com/questions/21136920/URGENT-Third-party-Oracle-tools.html
seazodiac, thanks, that's a good start. Now, I don't mean to get nitpicky, but I'm going to, only because my boss swears that I should be able to get the same productivity out of SQL Plus, if I just know the right commands and techniques.
-=-=-=-=-
My boss: Why do you need to drag and drop? You can cut and paste the same code into SQL Plus and run it. And why do you need to click a button to create a table, when the GUI is just sending DDL statements to the database, same as SQL Plus? And what does enhanced support mean? What could they possibly have that we can't get from the Oracle website?
-=-=-=-=-
I don't hink he'll be able to argue the version control integration, but then, we don't currently have much of a version control system in place.