Chat now with support
Chat with Support

SQL Navigator for Oracle 7.6 - 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

Task Bar

The Task Bar lists all active SQL Navigator windows for the current project.

Use the Task Bar to select a SQL Navigator window to work on. That window is bought to the foreground, giving it focus.

TIP:

  • To show / hide the Task Bar, right click over the Main Menu or Task Bar and click Task Bar (List of Windows).
  • Point to an item on the Task Bar with your mouse to see a Tool Tip for the associated window.
  • When there are lots of open SQL Navigator windows you may want to organize them on the Task Bar. Active windows are grouped by session, with the most recent session’s windows appearing on the left.

Toolbars

The following toolbars are available in the main window.

To show / hide a toolbar, right click over the Main Menu, any toolbar or task bar and select the toolbars to show.

Toolbar Description
Session Toolbar

Duplicates some of the commands from the Session Menu.

TIP: Pause/Resume and Stop buttons on the Session toolbar allow you to interrupt execution of a current task. A hint on the Stop button dynamically shows which task is running and (if applicable) its current progress.

Edit Toolbar Duplicates some of the commands from the File Menu and Edit Menu.
Functions Toolbar Duplicates some of the commands from the View Menu, Tools Menu and Help Menu.
Object Toolbar Duplicates some of the commands from the Object Menu and shows the current schema.
Team Coding Duplicates some of the commands from the Team Coding Menu.

TIP:

  • Some modules within SQL Navigator have their own toolbars. You should refer to the module's documentation for more information.
  • To see a Tool Tip about an item on the toolbar, point to it with the mouse.

Component List

Icon Component Name Description
Analyze Tool View and collect statistics, validate structure and list chained rows for database structures such as tables, clusters and indexes.

Auto Describe Tool

Report on the attributes, methods and arguments of an object type.

See also Describe.

Benchmark Factory Simulate user transactions before and during application deployments, enabling performance issues to be addressed before end users are affected.

Bookmarks Dialog

View / Jump to / Delete bookmarks.

See also Edit Menu.

Browse Data

View chained rows information.

See Quick Browse.

Change Logon Password Modify the logon password of the current session.
Cluster Editor Join tables that are closely related for storing on the same area of the disk. This lets you interleave the rows of two or more tables together into a single area called a cluster.
Code Analysis Analyze code against a set of rules for best practices.
Code Assistant Drag and drop PL/SQL syntax, SQL functions, column names, and database object names into code.
Code Editor Edit SQL and PL/SQL code.

Code Explorer

Show a hierarchical view the code.

See Code Editor | Toolbox | Code Explorer.

Code Road Map Show the complex PL/SQL interdependencies within a database.
Code Search See Database Source Code Search.
Code Templates Insert ready-made code segments into any active editor window.
Code Test Automate the process of testing PL/SQL programs.
Constraint Editor Use the Constraint Editor to specify table constraints.
Database Link Editor Use the Database Link Editor to view, create or define database links.
Database Source Code Search Search stored programs, triggers and views for a character string in the source code.

DB Explorer

Find and open database objects.

See Code Editor | Toolbox | DB Explorer.

DB Navigator Show the entire database structure as a tree with expandable nodes.

Describe

Report on the attributes, methods and arguments of an object type.

See also Auto Describe Tool.

Difference Viewer Compare objects in a split view.
Edit Data Edit data in a table object.
ER Diagram Model a table and graphically see the dependencies and joins to other tables.
Explain Plan Tool Analyze the execution of a single SQL statement.
Export Table Export selected tables.

Extract DDL

See also Object Menu.

See also SQL Navigator Preferences: View | PreferencesExtract DDL | General.

Find and Replace Find or replace text strings in the current text file.
Find objects Dialog Find objects in any schema.
Find Recycle Bin Objects Dialog Search for objects in the recycle bin.

Formatting Options

Configure how the Formatter Tool formats code.

Formatter tools are available from the Tools Menu.

HTML Viewer Show HTML in the integrated viewer.
Import HTML as PL/SQL Convert a HTML file into a PL/SQL stored procedure. The stored procedure will in turn output the HTML code via the Oracle Web Toolkit.
Import Table Import tables.
Index Editor Use the Index Editor to view, create or alter indexes, and to set storage allocation.
Instance Property Editor Use the Instance Property Editor to view or specify the startup parameters for the instance.
Java Editor View and edit Java source.
Java Manager Load and unload multiple Java source files, classes, resources and archives.
Job Scheduler Access the Oracle Job Scheduler.
Locate In Tree Jump to the selected object’s node in the DB Navigator tree.
Materialized View Editor Use the Materialized (Snapshot) View Editor to view, create or define snapshots.
Nested Table Editor Use the nested table editor when you require a large, efficient collection.

Open DB Object

Select and open a database object similar to the standard Windows File | Open command.

See Select DB Object Dialog.

Open Object at Cursor See Edit Menu.
Oracle Logon Dialog Manage your database connections, including to create a database connection.

Outline

Show the syntax tree of the current source.

See Code Editor | Toolbox | Outline.

Output Window Show SQL Navigator messages and server output including Oracle errors.

PL/SQL Debugger

Tools and features for debugging stored programs.

See Code Editor | Toolbox | PL/SQL Debugger.

PL/SQL Profiler Analyze the execution time and efficiency of your stored programs.
Profile Editor Use the Profile Editor to view, create or alter profiles.
Profile Manager Backup and Restore SQL Navigator profiles.
Product Authorization See Enter A New Authorization Key.
Project Manager The Project Manager window provides instant access to your frequently used database objects and connections.
Publish Java to PL/SQL Create a PL/SQL package from a Java class stored in the database.
Quick Browse View chained rows information.
Redo Log Group Editor Use the Redo Log Editor to view, create, or alter Redo Logs.
Role Editor Use the Role Editor to view or create roles.

Screen Layout

Save up to ten layouts of dockable windows and recall them.

See View Menu | Screen Layout

Search Knowledge Xpert Drag and drop optimized routines directly into your program editor.
Sequence Editor Use the Sequence Editor to view, create, or alter sequences.
Server Side Installation Wizard Install server side objects.
Select DB Object Dialog Select and open a database object similar to the standard Windows File | Open command.
Select Session Switch between open Oracle Sessions.
Session Browser Manage sessions in the Session Browser.
Source Preview Preview the source code of text objects (stored programs, triggers and views), or a package’s individual entry points.

SQL History

The History tool lists successfully executed SELECT, UPDATE, DELETE commands and PL/SQL blocks up to 1000 of the most recent ones in the current session.

See Code Editor | Toolbox | History

SQL Modeler SQL Modeler dialog provides a fast means for creating the framework of a Select, Insert, Update, or Delete statement. You can select Tables, Views, or Synonyms, join columns, select columns, and create the desired type of statement.
SQL Optimizer The SQL Optimizer makes observations about a selected SQL statement and the underlying database environment, then recommends several options to improve performance.
Synonym Editor Use the Synonym Editor to view or create synonyms.
Table Editor Use the Table Editor to create, alter, or define tables.
Task Manager SQL Navigator executes long-running tasks in separate threads in the background. The Task Manager is a display of all active and complete tasks for the current session.
User Editor Use the User Editor to create, grant or revoke roles and privileges to users, including forcing a password to expire.
Varray Editor Use the Varray Type Editor to create varying arrays.
View Editor Use the View Editor to view, create, or alter views.

View Difference

The Difference Viewer displays the compared objects in a split window.

See Difference Viewer.

Visual Object Editors SQL Navigator’s editing tools for database objects.
Wrap Code The Wrap Code utility provides an easy way to access Oracle’s Wrap Code utility.

Connection Category Color

Optionally assign a connection to a category color in the Oracle Logon Dialog.

Possible categories could be: development, test or production. You could create your own categories and assign colors as appropriate.

The color is displayed in the following places in SQL Navigator.

Component Name Description
Toolbars

The connection entry in Session toolbar.

 

The border of windows belonging to the connection.

Task Bar

Task Bar icons of windows belonging to the connection.

Code Editor

Tab icons of the Code Editor window.

See also preference settings in View | PreferencesGeneral | User Interface.

Related Documents

The document was helpful.

Select Rating

I easily found the information I needed.

Select Rating