SQL Navigator for Oracle 7.4 - Release Notes

The Code Test panel automates the process of testing PL/SQL programs.

Code Test

Code Analysis analyzes code against a set of rules for best practices.

Code Analysis

Compare two scripts / two objects.

View Differences Dialog

Format PL/SQL, SQL*Forms, Oracle Forms, and SQL*Plus source code.

Menu Icon	Menu Name	More Information
	Format Code	Format the entire source currently in the editor. To format just a selection, select the text you want to format. Output is displayed in the Output Window.
	Syntax Check	Check the syntax. Output is displayed in the Output Window. If syntax errors are detected, the text stays unchanged. The errors are displayed in the Output Window.
	Profile Code	Create a summary of the code statistics. You can copy to clipboard or save to file.
	Multi-File Formatting	Open the Multi-File Formatting Selection dialog. Select Folder and enter the folder that directly contains the files you want to format. Or Select Files and enter the files you want to format. Select Backup files to folder to create a backup copy of the files you are about to format.
	Formatting Options	Define how the Formatter Tool formats code. Formatting Options

Access Oracle’s Wrap Code utility.

Wrap Code

Manage sessions in the Session Browser.

Session Browser

Knowledge Xpert (formerly RevealNet) is a library of more than 900 pre-built PL/SQL routines, written by some of the world's leading PL/SQL experts, that can be integrated into the standard PL/SQL environment.

Search Knowledge Xpert

Analyze and tune the execution of SQL scripts.

SQL Optimizer

Requires installation of SQL Optimizer for Oracle.

Create, store and browse execution plans.

Explain Plan Tool

Analyze the execution time and efficiency of your stored programs.

PL/SQL Profiler

Create the framework of a Select, Insert, Update, or Delete statement.

SQL Modeler

Show the complex PL/SQL inter dependencies within a database.

Code Road Map

Model a table and graphically see the dependencies and joins to other tables.

ER Diagram

Work with Oracle Job Manager.

Job Scheduler

Load and unload multiple Java source files, classes, resources and archives. This is a convenient alternative to the Oracle LoadJava and UnloadJava command line utilities.

Java Manager

Convert a HTML file into a PL/SQL stored procedure, to be output via the Oracle Web Cartridge.

Import HTML as PL/SQL

Open Code Tester for Oracle.

Requires installation of Code Tester for Oracle.

Open Benchmark Factory.

Requires installation of Benchmark Factory.

Open Toad^® Data Modeler.

Requires installation of Toad Data Modeler.

Backup and restore SQL Navigator profiles.

Profile Manager

Open SQL Tracker.

Requires installation of SQL Tracker.

Install the server-side components of SQL Navigator

Server Side Installation Wizard