Features and Benefits

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 here (bundle diagram).

• Ensures efficient and accurate PL/SQL development 
• Easily develop and tune database code with enhanced interface
• Facilitates sharing to improve the efficiency of development teams
• Features a code review process that validates that code being deployed to production is of the highest quality regardless of user skill set
• Provides a consistent, repeatable and measurable process for managing the overall database development projects
• Improve database development with the ability to drag-and-drop SQL code
• Helps find the source of PL/SQL bottlenecks
• Provides visibility into PL/SQL code coverage
• Advanced support for version control integration
• Some editions include SQL Optimization to automatically rewrite SQL statements that may potentially compromise performance in production
• Knowledge Xpert for PL/SQL - Provides thousands of topics on background information, best practices and examples programmers need to write optimized, bulletproof code
• Support for Citrix environments
• LDAP support

• CodeXpert allows you to visualize your software quality, shorten test cycles, lower error rates, reduce maintenance efforts, uncover software changes, and locate high-risk code through industry leading metrics and test coverage techniques
• ER Diagram (entity relationship diagram) quickly model a table and graphically see the dependencies and joins to other tables
• Code Roadmap allows you to graphically see the complex interdependencies your PL/SQL code within the database
• Quest SQL Optimizer for Oracle is the integrated and enhanced SQL Tuning component (available in the SQL Navigator Xpert Edition) that provides optimization intelligence, best practices, scanning, inspecting and testing for scalability (with Benchmark Factory - available in SQL Navigator Development Suite)
  
  • SQL Tuning automates the optimization of SQL statements
• Job Scheduler helps you manage all of your jobs, job classes, schedules, and programs in one central location.
• Project Manager allows you to keep track of what you’ve been working on