Quest SQL Navigator vs. SQL*Plus

Posted on 2004-09-19
Medium Priority
Last Modified: 2008-02-01
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.
Question by:ftaco96
LVL 23

Accepted Solution

seazodiac earned 1800 total points
ID: 12097447
Try this blurb:

SQL Navigator® is a PL/SQL development solution that streamlines workflow by adding a drag-and-drop, graphical user interface to the PL/SQL development environment. SQL Navigator speeds the development of Oracle-based applications and combines coding, tuning, debugging, Web development and version control to deliver higher quality applications and save valuable time.

Key Benefits

Ensure optimal productivity and application performance

Improve database development with the ability to drag-and-drop SQL code

Easily develop and tune database code with enhanced GUI

Advanced support for version control integration

Enhanced support for Oracle 8i, 9i and JAVA databases


Author Comment

ID: 12097657
By the way, here's a pointer to another Q about 3rd party Oracle software in general:

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.
LVL 23

Expert Comment

ID: 12097692
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.

What does it mean to be "Always On"?

Is your cloud always on? With an Always On cloud you won't have to worry about downtime for maintenance or software application code updates, ensuring that your bottom line isn't affected.

LVL 22

Assisted Solution

by:Helena Marková
Helena Marková earned 80 total points
ID: 12099416
You can try this - it is free:

and also this PL/SQL Developer - it is not free:

Assisted Solution

jaramill earned 120 total points
ID: 12104650
Well from what I recall reading on a message board, Quest maybe going away with SQL Navigator and just promoting TOAD as their #1 IDE app for Oracle Database development.  To me the biggest thing with TOAD is their debugging capabilities with SQL scripts and PL/SQL stored procedures/functions/packages/triggers/views.  You can speed up coding itself with TOAD, with the features inside of it.  Yes you can code and debug in SQL+ Plus but that's like writing with a stone tablet and a chisel and a rock.  Or communicating with smoke signals.  Also the support you get with TOAD is phenomenal.  Just logon to the TOAD Yahoo Groups (and their beta version) and if there's a problem it will get fixed and put into the next beta and most likely the next General Acceptance release.

Just my 2 cents as I'm a TOAD lobbyist! :)


Author Comment

ID: 12228446
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.

Featured Post

Restore individual SQL databases with ease

Veeam Explorer for Microsoft SQL Server delivers an easy-to-use, wizard-driven interface for restoring your databases from a backup. No expert SQL background required. Web interface provides a complete view of all available SQL databases to simplify the recovery of lost database

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

How to Create User-Defined Aggregates in Oracle Before we begin creating these things, what are user-defined aggregates?  They are a feature introduced in Oracle 9i that allows a developer to create his or her own functions like "SUM", "AVG", and…
Configuring and using Oracle Database Gateway for ODBC Introduction First, a brief summary of what a Database Gateway is.  A Gateway is a set of driver agents and configurations that allow an Oracle database to communicate with other platforms…
Via a live example, show how to restore a database from backup after a simulated disk failure using RMAN.
This video shows how to copy an entire tablespace from one database to another database using Transportable Tablespace functionality.
Suggested Courses

809 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question