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
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
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.

Concerto Cloud for Software Providers & ISVs

Can Concerto Cloud Services help you focus on evolving your application offerings, while delivering the best cloud experience to your customers? From DevOps to revenue models and customer support, the answer is yes!

Learn how Concerto can help you.

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

Fill in the form and get your FREE NFR key NOW!

Veeam® is happy to provide a FREE NFR server license to certified engineers, trainers, and bloggers.  It allows for the non‑production use of Veeam Agent for Microsoft Windows. This license is valid for five workstations and two servers.

Question has a verified solution.

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

Cursors in Oracle: A cursor is used to process individual rows returned by database system for a query. In oracle every SQL statement executed by the oracle server has a private area. This area contains information about the SQL statement and the…
This post first appeared at Oracleinaction  (http://oracleinaction.com/undo-and-redo-in-oracle/)by Anju Garg (Myself). I  will demonstrate that undo for DML’s is stored both in undo tablespace and online redo logs. Then, we will analyze the reaso…
This video shows setup options and the basic steps and syntax for duplicating (cloning) a database from one instance to another. Examples are given for duplicating to the same machine and to different machines
This video shows how to set up a shell script to accept a positional parameter when called, pass that to a SQL script, accept the output from the statement back and then manipulate it in the Shell.

650 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