Configurations

Standard Edition

SQL Navigator® Standard Edition provides everything the Oracle professional needs to develop code, edit and manage database objects. SQL Navigator includes a powerful SQL Editor, a stored code editor, an explorer-type database browser and more, all optimized for the PL/SQL developer. The standard edition also includes a powerful offline syntax checking and code formatting feature designed to analyze and format entire PL/SQL applications.

You get instant code formatting for an entire application, or just a single file. You get instant code reviews - while you code – with best-practice recommendations for code correctness, maintainability, efficiency, readability and program structure. You get best-practice technical knowledge, coupled with real-world examples.

• Intelligent PL/SQL editors support color syntax highlighting and error checking, drag-and-drop coding and split window editing
• Query Builderallows even novice users to create SQL queries with an easy-to-use GUI
• PL/SQL Profiler displays SQL execution line by line and integrates with any installed tuning option for quick and accurate identification and resolution of problematic code
• Integrated PL/SQL Debugger for troubleshooting stored database code. The debugger provides a point-and-click method for identifying and correcting logic problems in stored code
• Multi-threaded for executing long-running queries in a separate thread in the background
• HTML pages can be easily converted to PL/SQL stored procedures
• Optional add-on modules offer PL/SQL debugging and Xpert tuning
• Complete integration with Knowledge Xperts
• Robust reporting tool creates formatted documents describing all database object types
• Optional server-side installation requires little tablespace, resulting in minimal demand on database storage
• Project Manager – manage all of your jobs, job classes, schedules, and programs in one central location
• Job Scheduler – keep track of what you’ve been working on 

Optional add-on Modules: Extend the reach of SQL Navigator with powerful add-ons designed to provide intelligence and optimize PL/SQL server-side development.

Professional Edition

The SQL Navigator® Professional Edition includes all of the features of SQL Navigator Standard Edition plus CodeXpert with automates finding problematic SQL statements with a new scanning feature and the addition of a CRUD matrix for reporting script and PL/SQL data access. Also included is the Knowledge Xpert for PL/SQL Development – providing coding insights, best practices, diagrams and reusable examples of the entire lifecycle of PL/SQL development.

Optional add-on Modules: Extend the reach of SQL Navigator with powerful add-ons designed to provide intelligence and optimize PL/SQL server-side development.

Xpert Edition

The SQL Navigator® Xpert Edition includes all of the features and functionality of SQL Navigator Professional Edition plus our Xpert Tuning. Xpert Tuning allows developers to analyze and automatically rewrite inefficient SQL queries while they are being built. Xpert tuning is an absolute must have for developers who want the highest performance from their database applications.

SQL Navigator Development Suite

Building on the foundation of SQL Navigator and leveraging a proactive automated methodology developed by industry experts, the SQL Navigator Development Suite provides an integrated toolset to ensure that the highest quality of code is delivered, optimized and scaled for better performance -- regardless of user skill set.

Optional Add-on Modules

• Knowledge Xpert ™ for PL/SQL covers the lifecycle of Oracle PL/SQL programming, offering a wealth of technical knowledge, best practices and reusable examples. Thousands of topics provide the background information, syntax and working examples you need to apply solutions immediately. Includes PL/Vision, a robust code library with over 1,000 useful PL/SQL functions and procedures.
  
  
• Knowledge Xpert™ for Oracle Administration answers 70-80 percent of your daily Oracle administration questions instantly. Thousands of topics provide the background information, syntax and working examples you need to apply solutions immediately. Includes new "Database Analysis" feature that studies your database and delivers technical content "customized" for your environment.
  
  
• Users can increase SQL Navigator's power and flexibility with Benchmark Factory for Databases, to test user load on your Oracle databases. The integrated add-on (optional) is a highly scalable load testing, capacity planning and performance tuning tool. Benchmark Factory® allows users to proactively evaluate how applications would perform when deployed with real activity; determines system capacity; pinpoints system bottlenecks; and isolates system stress related problems.
  

• Quest Software's Toad Data Modeler helps organizations create, maintain and document their database systems with an easy-to-use graphical interface into new or existing database structures. Toad Data Modeler enables users to reverse engineer over 20 different databases, design and generate SQL, create HTML or RTF reports, and generate data flow diagrams, in addition to versioning of database designs and creation of to-do lists.

• Quest Code Tester for Oracle generates test code and run tests with the press of a button.  Success or failure is computed automatically and presented to users via an easy to understand red light-green light display.  As a result, Quest Code Tester for Oracle integrates PL/SQL testing directly into development, as a repeatable, verifiable process.