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

Edit Menu

Navigation > Main Menu > Edit Menu

Common text and code-editing actions.

Menu Icon

Menu Name

More Information

Undo

Reverse the previous editing action.

Redo

Reapply the previous editing action

Cut

Remove selected text and place it on the clipboard

Copy

Copy selected text to the clipboard

Paste

Insert the clipboard contents at the cursor location.

Select All

Select all text in the item being edited

Indent

Indent the current line

To increase or decrease the indent of selected text in the editor

Unindent

Unindent the current line

To increase or decrease the indent of selected text in the editor

Comment

Enclose the selected text inside PL/SQL comment marks

Uncomment

Remove the PL/SQL comment marks from the selected text

Upper Case

Convert selected text to upper case

Lower Case

Convert selected text to lower case

Convert Keywords to Upper Case

Convert all keywords and reserved words in the program to uppercase

Convert Keywords to Lower Case

Convert all keywords and reserved words in the program to lowercase

Open Selected Text in Code Editor

Place selected text in the Code Editor

Nil

Insert

Menu Icon	Menu Name	More Information
	File	Insert a text file at the current cursor location.
	DBMS_OUTPUT.PUT_LINE(")	Insert DBMS_OUTPUT.PUT_LINE('') at the current cursor location. This procedure displays program output after execution. For more information, see DBMS_OUTPUT.
	Debug Variable	Create a debugging statement for the variable at the current cursor location. The statement is copied to the clipboard. Use Edit \| Paste to place the statement in the code.
	CRUD Matrix	Insert a CRUD (Create-Update-Delete) matrix, enclosed in comment markers, at the current cursor location in the Code Editor. This provides a convenient method of documenting a procedure. SQL Statement CRUD Matrix Dialog

Got to Line

Move to a specific line number in the editor.

Jump to Matching Bracket

Move to the other bracket within a given pair of brackets

Toggle Bookmark

Place a bookmark at the current line.

You can set up to ten bookmarks (identified numerically 0-9).

Go to Bookmark

Return to a bookmarked line in the code.

Example Scenario: Set bookmark number 1 in the DECLARE section and bookmark number 2 at your current editing location. To return to the DECLARE section press Ctrl+1. After looking at your variable or cursor declarations, return to your editing location by pressing Ctrl+2.

List Bookmarks

View / Go to / Delete bookmarked lines in the code.

Bookmarks Dialog

Open Object at Cursor

Open the database object referenced at the current cursor location.

Use to instantly find objects from stored programs or scripts, and open them in the Visual Object Editors.

Describe Object at Cursor

Show DESCRIBE information for the database object referenced at the current cursor location.

Search Menu

Navigation > Main Menu > Search Menu

Find text, code and database objects.

Menu Icon	Menu Name	More Information
	Find	Find a text string. Find and Replace
	Replace	Find a text string and replace it with another. Find and Replace
	Find Next	Find the next occurrence as per Find and Replace
	Find previous	Find the previous occurrence as per Find and Replace
	Code Search	Find source code in the database. Database Source Code Search
	Find Objects	Find one or more database objects matching a search argument. Find objects Dialog
	Find Recycle Bin Objects	Find Recycle Bin Objects Dialog Requires Oracle 10g or later.

View Menu

Navigation > Main Menu > View Menu

Control what is displayed in the main application area.

Menu Icon

Menu Name

More Information

DB Navigator

Open / Focus DB Navigator

Code Editor

Open / Focus Code Editor

Visual Object Editor

Visual Object Editors

Menu Icon	Menu Name	More Information
	Cluster Editor	Open a new instance of the Cluster Editor
	Constraint Editor	Open a new instance of the Constraint Editor
	DataBase Link Editor	Open a new instance of the Database Link Editor
	Index Editor	Open a new instance of the Index Editor
	Nested Table Editor	Open a new instance of the Nested Table Editor
	Profile Editor	Open a new instance of the Profile Editor
	Redo Log Group Editor	Open a new instance of the Redo Log Group Editor
	Role Editor	Open a new instance of the Role Editor
	Materialized View Editor	Open a new instance of the Materialized View Editor
	Sequence Editor	Open a new instance of the Sequence Editor
	Synonym Editor	Open a new instance of the Synonym Editor
	Table Editor	Open a new instance of the Table Editor
	user Editor	Open a new instance of the User Editor
	Varray Editor	Open a new instance of the Varray Editor
	View Editor	Open a new instance of the View Editor
	Java Editor	Open a new instance of the Java Editor
	Instance Property Editor	Open a new instance of the Instance Property Editor