SQL Navigator for Oracle 7.4

Oracle Logon Dialog Oracle TNS Configuration Dialog Advanced Service Options Dialog Address List Options Dialog DBA Dictionary Views Troubleshooting Connections to Oracle Command Line Parameters

Code Editor

Code Editor SQL Code Editor PL/SQL Edit, Compile And Execute

SQL*Plus command support Auto Code Completion Scan Defines/Substitutions New Stored Object Dialog SQL Statement CRUD Matrix Dialog

SQL Query Results

SQL Query Results Data Grid SQL Query Log (The Spool Tab) Export Data Dialog Viewers: LOB, XML, Array

PL/SQL Execution Console

PL/SQL Stub DBMS_OUTPUT

Code Editor Keyboard Shortcuts Toolbox

PL/SQL Debugger Code Explorer Outline DB Explorer Describe History Dependencies Columns

Visual Object Editors

Cluster Editor Constraint Editor Database Link Editor Index Editor Nested Table Editor Profile Editor Redo Log Group Editor Role Editor Materialized View Editor Sequence Editor Synonym Editor Table Editor User Editor Varray Editor View Editor Java Editor Instance Property Editor

Team Coding and Version Control Systems

Objects Supported by Team Coding Administer Team Coding

Install Team Coding Team Coding Settings Team Projects

Setup Team Projects

Team Coding Roles

Configure Team Coding

Configure Concurrent Version Systems (CVS) Configure Git Configure IBM Rational ClearCase Configure Perforce (P4) Configure Serena PVCS Version Manager Configure Subversion Configure Team Foundation Server

Team Coding Status Team Coding Manager Provider logon

Using Git Using Perforce Using IBM Rational ClearCase

Check in and Check out Version Control Systems

Concurrent Version Systems (CVS) Requirements More about Git and SQL Navigator More about Rational ClearCase and SQL Navigator More about Perforce and SQL Navigator More about Team Foundation Server and SQL Navigator

Modules, Windows And Dialogs

Analyze Tool Auto Describe Tool Benchmark Factory Bookmarks Dialog Capture Web Output Change Logon Password Dialog Code Analysis

Code Analysis Window Code Analysis Rule Sets Code Analysis Rules

Code Assistant

Add to Catalog & Edit Dialogs

Code Road Map

Model Code Dialog

Code Templates

Code Shortcuts And Templates Dialog

Code Test

Test Case Properties

Database Source Code Search Dialog DB Navigator

Filter Properties Dialog

Describe Difference Viewer

View Differences Dialog Difference Viewer | Options Difference Viewer | Rules

Edit Data ER Diagram

Create 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

Jobs Tab Programs Tab Schedules Tab Windows Tab Window Groups Tab Job Classes Tab Job Log Tab Window Log Tab Job Scheduler (Requirements)

Locate In Tree Output Window PL/SQL Profiler

Profiler Filter/Preferences Dialog New Group / Group Properties Dialog PL/SQL Profiler Requirements

Profile Manager Project Manager

Project Filter Dialog

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

Toolbar

View Joins Dialog Global WHERE Conditions Window Global HAVING Coditions Window

Model Area Tabs

Criteria Generated Query Query Results

SQL Optimizer Task Manager Web Support Configuration Dialog Wrap Code

View | Preferences

General

Extract DDL

Project Manager Code Editor

Code Editor | General Code Editor | SQL Scripts

Lob Viewer Team Coding Keyboard Shortcuts

About Us

Technical support resources Copyright information Third-party contributions

Add to Catalog & Edit Dialogs

Modules, Windows And Dialogs > Code Assistant > Add to Catalog & Edit Dialogs

Add a code snippet or folder to the Code Assistant Code and SQL Catalog. Manage items in the catalog.

Field

Description

Name

Make the name descriptive.

Names can be up to 35 characters long and contain uppercase letters, lowercase letters, and any of the following characters:

_ - & space < > / , ' ( ) ..

Entry Type

Select Code Snippet or Folder.

Snippet

The snippet of code.

Note: For code snippets only.

Information

The text to be displayed in the Code Assistant Information pane.

Hint

The text to be used as a hint in the status bar at the bottom of the Code Assistant window.

Image

The icon to identify the code snippet in the catalog (Generic, Function, or Procedure).

Note: For code snippets only.

Code Road Map

Modules, Windows And Dialogs > Code Road Map

The Code Road Map graphically displays the complex PL/SQL interdependencies within a database.

Code Road Map Toolbar

Icon

Tool Tip

Description

New code road map

This opens the Model Code Dialog.

Clear diagram

Clear the model window. Revert to the initial start up state.

Open file

Open a saved map file (Extension: .crm).

Save file as

Save the map with a new name (Extension: .crm).

Save file

Save the map (Extension: .crm).

Save diagram as text file

Save the map as a text file.

The file consists of a list of the objects and what they reference.

For example the following might be the results of a small code map:

PROCEDURE CRM_TEST EX_PROC_1 ---> PACKAGE CRM_TEST EX_PACK_2

PROCEDURE CRM_TEST EX_PROC_1 ---> PROCEDURE CRM_TEST EX_PROC_2

PROCEDURE CRM_TEST EX_PROC_1 ---> PROCEDURE CRM_TEST EX_PROC_3

PROCEDURE CRM_TEST EX_PROC_1 ---> TABLE CRM_TEST EMP_SNAPSHOT

PROCEDURE CRM_TEST EX_PROC_1 ---> VIEW CRM_TEST SALES

The map is laid out as follows where the arrow means "calls".

OBJECT-TYPE SCHEMA OBJECT NAME --> OBJECT-TYPE SCHEMA OBJECT NAME

Save diagram as bitmap

Create a bitmap version of the map.

TIP: You could copy the image to the clipboard. Right click over the map and select Copy Image to Clipboard.

Print diagram

Print the model side of the map.

Print preview

Preview before printing.

Code road map info

Add a comment to your code map.

Collapse packages

Collapse/Expand Package View.

Icon	Tool Tip	Description
	Collapse Packages	Show/Hide referenced sub units under the object type.
	Expand Packages	Show/Hide referenced sub units under the object type.

Note: Applicable to Code Type | Package as set in the Model Code Dialog.

Refresh diagram

Refresh the diagram.

Choose colors for database objects

Color code database objects.

Zoom

Zoom in or out of the model.

Previous auto layout / Next auto layout

Scroll through layouts of the Code Road Map.

The Code Model

The code model consists of two panels. The left panel shows a list of components in a hierarchical tree. The right panel shows a graphic model of the code. The design is similar to models created using SQL Modeler.

Hierarchical Tree	Graphical Model
The hierarchical tree is organized by object type. All procedures are listed under the Procedures node, and all tables under the Tables node. Click on an object to highlight it in the Graphical Model.	Each object listing contains the name of the object, the schema where it resides, and the type of object. For Code Type \| Package in Collapse Package view, any sub units that are referenced will be included under the object type. For example: Lines indicate where an object is dependent on another. Lines have a knob end (the referencing object) and an arrow end (the referenced object). In this example, DISK_UTIL references the library NT_KERNEL, specifically from the function GET_DISK_FREE_SPACE. The model is in Collapse Package view. A self-recursive reference is shown with the arrow returning back to the object, as follows:
Actions: Click on an object in the tree view and the Graphic Model centers on that object. Right-click on an object to display the popup menu from the Schema Browser for that object. F4 performs a Describe, if SQL Navigator supports Describes on that object type. Double-click an object to perform a Describe.	Actions: Right-click on an object to display the popup menu from the Schema Browser for that object type. F2 toggles full screen mode. F4 or Double-clicking on an object performs a Describe, if SQL Navigator supports Describes on that object type.

Hierarchical Tree

Graphical Model

The hierarchical tree is organized by object type. All procedures are listed under the Procedures node, and all tables under the Tables node.

Click on an object to highlight it in the Graphical Model.

Each object listing contains the name of the object, the schema where it resides, and the type of object. For Code Type | Package in Collapse Package view, any sub units that are referenced will be included under the object type. For example:

Lines indicate where an object is dependent on another. Lines have a knob end (the referencing object) and an arrow end (the referenced object).

In this example, DISK_UTIL references the library NT_KERNEL, specifically from the function GET_DISK_FREE_SPACE. The model is in Collapse Package view.

A self-recursive reference is shown with the arrow returning back to the object, as follows:

Actions:

Click on an object in the tree view and the Graphic Model centers on that object.
Right-click on an object to display the popup menu from the Schema Browser for that object.
F4 performs a Describe, if SQL Navigator supports Describes on that object type.
Double-click an object to perform a Describe.

Actions:

Right-click on an object to display the popup menu from the Schema Browser for that object type.
F2 toggles full screen mode.
F4 or Double-clicking on an object performs a Describe, if SQL Navigator supports Describes on that object type.

Model Code Dialog

Modules, Windows And Dialogs > Code Road Map > Model Code Dialog

Select the code to map and the options to use when the code is mapped.

Field

Description

Schema

The schema where the code is located.

Code Type

Select from: function, package, procedure and trigger.

Code Unit

The options depend on the Code Type selected.

Sub Unit

The various parts of the package, sorted alphabetically. The first sub unit is selected by default.

Note: Visible for Code Type | Package.

Levels to Model

The number of levels to model down from the starting object. The default is ten.

Display Mode

Option

Description

Code Only

Model the code the object calls.

Display a graphical representation of the run-time, call-stack dependencies.

Code + Data

Model both the code called and data (tables, views, and so on) referenced by the object.

Display the database objects the code references and in what manner (for example, read versus write). You can also include pertinent triggers and views. Views are essentially treated as tables.

Display Options

Select as appropriate. These options affect the visual display of the map. The data in the map is not affected.

Expand packages and types for calls into them
Include triggers (for Code + Data)
Include views (for Code + Data)
Include calls to SYS-owned objects
Include calls to other schema PL/SQL

Code Templates

Modules, Windows And Dialogs > Code Templates

Insert ready-made code segments into any active editor window.

Action	Description
Insert code from a template into an active editor window.	In the editor, place the cursor where you want to insert the code segment. Choose one of the following: Type the shortcut key to the code template. Type the full or partial name of the code template and press Ctrl+J to either insert the matching code template or select from a list of matches. Press Ctrl+J. Select the template name from the drop-down list and press Enter.
Add / Edit / Delete code templates.	Click View \| Code Templates \| Edit Code Templates. This opens the Code Shortcuts And Templates Dialog Each template is a file in the SQL Navigator installation Templates directory. The maximum number of templates allowed, including preformatted templates, is 100.

Action

Description

Insert code from a template into an active editor window.

In the editor, place the cursor where you want to insert the code segment.
Choose one of the following:
- Type the shortcut key to the code template.
- Type the full or partial name of the code template and press Ctrl+J to either insert the matching code template or select from a list of matches.
- Press Ctrl+J. Select the template name from the drop-down list and press Enter.

Add / Edit / Delete code templates.

Click View | Code Templates | Edit Code Templates. This opens the Code Shortcuts And Templates Dialog

Each template is a file in the SQL Navigator installation Templates directory.

The maximum number of templates allowed, including preformatted templates, is 100.

Standard code routines for which templates have been provided:

Code Description	Shortcut Key
Basic Loop Statement	Shift+Ctrl+L
Boolean Statement	Shift+Ctrl+B
Close Cursor Statement	Shift+Ctrl+C
DBMS_OUTPUT.Put_Line	Shift+Ctrl+D
Exception	Shift+Ctrl+E
Exit When Statement	Shift+Ctrl+X
For Loop Statement	Shift+Ctrl+F
GOTO Label Statement	Shift+Ctrl+G
IF Statement	Shift+Ctrl+A
MLSLABEL Statement	Shift+Ctrl+M
Number Statement	Shift+Ctrl+N
Open_Cursor Statement	Shift+Ctrl+O
Raise_Exception	Shift+Ctrl+R
SQLCODE Statement	Shift+Ctrl+S
VARCHAR2 Statement	Shift+Ctrl+V
Variable_name	Shift+Ctrl+T
While Condition Statement	Shift+Ctrl+W

Please select your product:

To serve you better, please complete the Purpose of your Chat:

Recommended Solutions for Your Problem

SQL Navigator for Oracle 7.4 - User Guide

Add to Catalog & Edit Dialogs

Code Road Map

Code Road Map Toolbar

The Code Model

Model Code Dialog

Code Templates

Standard code routines for which templates have been provided: