Chat now with support
Chat with Support

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

Edit Data

Use to edit data in a table object.

  1. Select the table object.
  2. Click Object | Edit Data.
  3. The Code Editor opens. The query is run with Updateable switched on. For more information, see SQL Query Results Data Grid.

ER Diagram

The ER (Entity Relationship) diagrammer lets you quickly model a table and graphically see the dependencies and joins to other tables.

Note: To ensure indexes are delivered in the correct order in a diagram, ensure the Oracle Data Dictionary is queried with DBA Views. For more information, see DBA Dictionary Views.

 

ER Diagram Toolbar

Icon Tool Tip Description
New ER Diagram Opens Create ER Diagram.
Clear ER Diagram Clear the ER Diagram window.
Open File Open a saved ER Diagram.
Save File As Save the ER Diagram.
Save File
Save Diagram as Bitmap
Print Diagram Print the ER Diagram.
Print Preview
ER Diagram Info Show detail of the ER Diagram.
Load ER Diagram in the SQL Modeler For more information on the SQL Modeler, see SQL Modeler.

Find Table Dependencies

Show joins between tables.

This feature does not add new objects to the diagram; it only finds joins between objects already displayed.

Refresh Diagram Refresh the ER Diagram window.
Scale Zoom in / out of the window.
Previous auto-layout / Next auto-layout Scroll through the layouts.

 

ER Diagram Display Area

For each table in the model

Diagram Part Description
Title Bar The name of the table and schema it resides.
Body Area The columns in the table, the column type, whether the column is indexed, and icons as applicable and selected in Create ER Diagram.
Connector Lines Lines connect tables that are dependent on each other. Lines have a knob end and an arrow end. The referencing table resides at the knob end, and the referenced table at the arrow end.

To add tables to the diagram

Drag-and-drop from:

Create ER Diagram

Field Description
Schema Select the Schema where the table resides.
Table Select the table to diagram.

How many levels of referential tables do you want to load?

Select as appropriate.

The more levels of referential tables you load, the more complicated the diagram will become, and the longer SQL Navigator will take to create the diagram.

Display Options

Select from:

  • Show primary keys
  • Show foreign keys
  • Show unique keys
  • Show data type
  • Show not nullable
  • Show indexes

If the display option has an icon associated with it, the icon is displayed to the right of the option. In the diagram, the appropriate icon will appear to the left of the table name.

Explain Plan Tool

Use the Explain Plan tool to analyze the execution of a single SQL statement. By examining the execution plan, you can see exactly how Oracle executes your SQL statement, and how it can be improved.

This tool lets you:

  • generate plans and save them in the table of your choice
  • organize your saved plans by various criteria, such as type (for example, online SQL statements, batch SQL statements, and so on), module, or subsystem
  • build separate plan tables for different subsystems in your project
  • browse each table separately.

TIP: The Analyze Tool can be used in conjunction with the Explain Plan tool. The Explain Plan Tool does not analyze tables itself prior to executing the Explain Plan, but it does have a toolbar button for manual launch of the Analyze Tool.

Explain Plan Window

Generate Plans

Drag a SQL Statement into the editor on this tab.

Option Description
Stmt ID If required, you can enter a Statement ID to identify the statement within the current plan table.
Save SQL text Select to save the SQL when saving the generated plan.
Comment Optionally, comment on the plan.
Plan Table Owner Enter the Plan Table Owner or use the default listed.

Name

Enter the Plan Table Name or use the default listed.

TIP: If specifying a new plan table, use the Create Table button to create the table.

Generate Click to view the Oracle execution plan for the statement.
Browse Saved Plans Browse previously saved execution plans.

Operation Description

Explain the node selected in the Explain Plan tree. Show how each SQL operation is executed in relation in the Explain Plan.

Show / Hide in Generate Plans | Show Description.

Plan The generated execution plan. Click on nodes to expand and collapse them.

 

Print the Explain Plan tree

Use File | Print.

The following data is printed:

  • The SQL Statement from which the explain plan tree was derived
  • Statement ID, Type, Cost and Time stamp
  • The Explain Plan tree, including the execution sequence numbers in brackets

TIP:

  • When the printout exceeds one page, the headings (such as the SQL Text and statement ID lines) are not repeated. This makes it easy for you to 'tile' multiple pages together to display the explain plan tree as a single diagram.
  • Use File | Print Preview to preview your output.
Related Documents

The document was helpful.

Select Rating

I easily found the information I needed.

Select Rating