Chat now with support
Chat with Support

SQL Navigator for Oracle 7.4 - User Guide

Quick Overview Working With SQL Navigator Navigation Oracle Logon Code Editor Visual Object Editors Team Coding and Version Control Systems Modules, Windows And Dialogs
Analyze Tool Auto Describe Tool Benchmark Factory Bookmarks Dialog Capture Web Output Change Logon Password Dialog Code Analysis Code Assistant Code Road Map Code Templates Code Test Database Source Code Search Dialog DB Navigator Describe Difference Viewer Edit Data ER Diagram Explain Plan Tool Export Table Find and Replace Dialog Find objects Dialog Find Recycle Bin Objects Dialog Formatting Options HTML Viewer Import HTML as PL/SQL Import Table Java Manager Job Scheduler Locate In Tree Output Window PL/SQL Profiler Profile Manager Project Manager Publish Java to PL/SQL Quick Browse Rename Object Search Knowledge Xpert Select DB Object Dialog Server Output Server Side Installation Wizard Session Browser Source Preview SQL Modeler SQL Optimizer Task Manager Web Support Configuration Dialog Wrap Code
View | Preferences About Us

Generated Query

Modules, Windows And Dialogs > SQL Modeler > Tabs > Generated Query

This tab lists the automatically generated SQL statement.


  • Any changes made to the Model Area or Criteria Tab will automatically regenerate this SQL statement.
  • You cannot directly edit the SQL on the Generated Query tab.


Right-click over the query

Menu Description


Copy the query to the clipboard.

Save As

Save the query to a file.

View Query in Code Editor

Copy the query directly to the Code Editor.

Query Results

Modules, Windows And Dialogs > SQL Modeler > Tabs > Query Results

Show the results of executing the generated query.


  • Insert, Update, and Delete queries can only be executed in the Code Editor.
  • Making changes to the Tables or Columns, then clicking on the Query Results tab will prompt you whether or not to re-query the data.

SQL Optimizer

Modules, Windows And Dialogs > SQL Optimizer

SQL Optimizer supplements Oracle tuning skills for developers. The SQL Optimizer makes observations about a selected SQL statement and the underlying database environment, then recommends several options to improve performance. Users can then view the logic behind the advice, implement the recommendation, apply it to the database, and see the results. The SQL Optimizer module automatically produces all necessary SQL to effect the corresponding change.


  • SQL Optimizer can be used to analyze the execution of SQL scripts containing more than one statement.
  • SQL Optimizer is an external application. It is installed independently of SQL Navigator.
  • Example Scenario: in the Code Editor highlight the text of the SQL statement you want to investigate and click SQL Optimizer.
  • For more details, see the online help supplied with the SQL Optimizer product.

Task Manager

Modules, Windows And Dialogs > Task Manager

SQL Navigator executes long-running tasks in separate threads in the background. They lock only the current session. Background execution happens automatically, and means that all the application’s functionality remains available to the user while the task is running in a separate session.

The Task Manager is a display of all active and complete tasks for the current session.

The following background tasks can be managed through the Task Manager:

Background Tasks More Information
Batch commands on database objects, such as Drop, Compile, Truncate and Extract DDL Object Menu
Enable Constraint Editor
Execute PL/SQL code PL/SQL Execution Console
View Differences Difference Viewer
Full expansion of a node in DB Navigator DB Navigator
Source Code Search Database Source Code Search
Find Objects Find and Replace



  • Right click on a task to Suspend, Resume, End or Delete.
  • Ending some tasks, such as compiling dependants in a complex table, may appear to "hang." This is due to SQL Navigator waiting for a response from the Oracle server. Even though there may be a delay, control will ultimately be returned to SQL Navigator.
Related Documents

The document was helpful.

Select Rating

I easily found the information I needed.

Select Rating