SQL Navigator Tutorial
VAUGHNLEA LEONARD
TECH
SQL Navigator is a tool that helps SQL users and developers maneuver databases. Formatted around Structured Query Language, the application reduces human error and vastly improves database performance.
1 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.
2 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.
3 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.
Related Articles
