Product Demo
Learn how to be more productive and deliver optimized, production-ready code – faster – with the SQL Navigator® Development Suite.
Watch demo »
SQL Navigator
Visit shop.quest.com to buy this product online.
Buy Online »
Quest Support
  • Global Coverage
  • Highly Skilled Engineers
  • Commitment to Customer Satisfaction
  • Flexible Support Offerings
Learn more »
Case Study
See how the IT staff at Valencia Community College cut development and QA time in half with SQL Navigator®.
Read now »

SQL Navigator

Better Code, Faster

SQL Navigator® makes it simple to write, edit, and maintain database objects through automation and an easy-to-use graphical interface. So you can deliver high-quality applications faster than ever. And SQL Navigator doesn’t just offer basic development and debugging help. It actually prevents performance issues from impacting production and end users with robust SQL optimization.

SQL Navigator is available in four editions: SQL Navigator Base Edition, SQL Navigator Professional Edition, SQL Navigator Xpert Edition and SQL Navigator Development Suite. View details on the available bundles.

Features

Features:

  • Code Xpert — Reveals software quality, shortens test cycles, lowers error rates, reduces maintenance efforts, uncovers software changes, and locates high-risk code through industry-leading metrics and test coverage techniques
  • ER Diagram — Lets you model a table and see the dependencies and joins to other tables
  • Code Road Map — Showcases the complex interdependencies of your PL/SQL code within the database
  • Quest® SQL Optimizer for Oracle — Offers an integrated and enhanced SQL optimization functionality, available in the SQL Navigator Xpert Edition, and provides intelligent recommendations, SQL scanning, and index optimization
  • Job Scheduler — Helps manage all of your jobs, job classes, schedules, and programs in one central location
  • Project Manager — Allows you to keep track of the projects you work on and share them

Benefits:

  • Ensures efficient and accurate PL/SQL development
  • Facilitates sharing to improve team efficiency
  • Employs a code-review process to ensure only high-quality code is deployed
  • Provides a consistent, repeatable, and measurable process for managing database development projects
  • Allows you to drag-and-drop SQL code
  • Provides visibility into PL/SQL code coverage
  • Offers advanced support for version control integration
  • Includes SQL optimization, in some editions, to automatically rewrite SQL statements that may compromise performance in production
  • Supports Citrix environments and LDAP

Sys Reqs

System Requirements:

Before installing SQL Navigator, ensure your system meets the following minimum hardware and software requirements:

PlatformIntel Pentium 4
MemoryMinimum 1GB
Hard Disk Space250MB**
DisplayXGA (1024x768) or better monitor
DirectDraw 7 capable graphics adapter
Operating System

Note:

- SQL Navigator supports 64-bit for Windows XP/Win7 with a 32-bit Oracle Client.

- It is recommended that you have the latest Windows Service Pack and Updates.

Oracle Client

Client (32-bit only)

  • Oracle v8i Client Net 8
  • Oracle v9 Client (Net 9)
  • Oracle v10 Client (Net 10) or Instant Client v10
  • Oracle v11 Client (Net 11) or Instant Client v11
Oracle ServerOracle versions 8.1.7; 9i; 9iR2; 10gR1; 10gR2; 11gR1, 11gR2

However it is recommended that you connect to Oracle 9i or above databases via Oracle client versions 9i or above. 

Please refer to the Oracle documentation for 10g or above instant client server compatibility.

Citrix/Terminal Server Support

Citrix products supported include:

  • Platform Level - MetaFrame XPa 1.0 Server for Windows
  • Feature Release - MetaFrame XP 1.0, Feature Release 1,2 and 3.


For installation notes on installing SQL Navigator in a Citrix environment, refer to the Installation section in "Getting Started" below.

** More disk space required for Xpert installation, less for Standard & Professional Editions.

Language Supported:

  • US English

Videos