Basics

• Structured query language (SQL) is the main method used to get databases to work. SQL Navigator lets users execute commands, clauses and operators. These are typical SQL phrases, already prepackaged into the Navigator tool. PL/SQL code allows users to troubleshoot scripts as well.
  
  

Features

• Many of the several types of SQL Navigator tools work in similar ways. One efficient SQL Navigator feature is the Explain Plan tool, which enables systems essentially to preview how SQL queries run before they are implemented. System developers can then revise SQL scripts to debug potential problems.
  
  

Connections

• SQL Navigator must connect to a database before a user may obtain information. It does this either via the Sessions menu or Session toolbar button. Many people opt for the Workspace connection, however. It is a little quicker, so just click on "View," then "Workspace Window," then choose the name of the database, which generally appears on the right-hand side of the screen.