SQL Navigator vs Toad 2009

Posted on 2009-02-18
Last Modified: 2013-12-19
I have read some reviews comparing SQL Navigator with TOAD for Oracle, but they are several years old.  I currently program using PL/SQL via sqlplus and I use ToRa as well.   However, I now need the ability to print out an ERD for a developer who will be writing a new web-based front end for an Oracle Database application I have written that currently uses a Microsoft Access front end.  I also have never gotten the hang of using an Oracle debugger on this system and need something that allows one to set breakpoints and monitor program execution in sessions other than the one the debugger is running in.

A new analyst working for us has used SQL Navigator and we were thinking of purchasing it.  But when I looked it up on Quest, I also saw the TOAD product.  In looking at reviews from a 2005, people were speculating that Quest was going to be concentrating on TOAD and that was the route to go.  But, 4 years later, I am trying to get a feel for where these two products are now and which way, if either, to go.

Question by:sjlevine34
    LVL 11

    Accepted Solution

    Depends on your requirements and level of development. TOAD is mainly a development tool (not as detailed as SQL Navigator) with some dba functions added. TOAD also comes with debugger (separate license) of course. SQL Tuning feature is also very powerful. Go with TOAD, you can always add SQL Navigator feature if needed.

    LVL 34

    Assisted Solution

    by:Mark Geerlings
    Our developers use TOAD and like it.  I find that the "free" (well at least you don't pay extra for it, its included in the Oracle DB software license) Oracle tool: "SQL Developer" offers the ability to debug PL\SQL code, set breakpoints, monitor PL\SQL procedures running in other sessions, etc.  It may not be quite as easy to use as TOAD, but its hard to beat the price!  It also has most of the same features that TOAD has.

    Expert Comment

    SQL navigator is much faster than TOAD. If are doing straight development work and do not need the fancy DBA tools, i recommend SQL Nav 6.1  (searching for code in SQL Nav is much easier/faster than with TOAD)

    Featured Post

    Gigs: Get Your Project Delivered by an Expert

    Select from freelancers specializing in everything from database administration to programming, who have proven themselves as experts in their field. Hire the best, collaborate easily, pay securely and get projects done right.

    Join & Write a Comment

    Working with Network Access Control Lists in Oracle 11g (part 2) Part 1: Previously, I introduced the basics of network ACL's including how to create, delete and modify entries to allow and deny access.  For many…
    I remember the day when someone asked me to create a user for an application developement. The user should be able to create views and materialized views and, so, I used the following syntax: (CODE) This way, I guessed, I would ensure that use…
    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
    Via a live example, show how to restore a database from backup after a simulated disk failure using RMAN.

    754 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

    Need Help in Real-Time?

    Connect with top rated Experts

    18 Experts available now in Live!

    Get 1:1 Help Now