Chat now with support
Chat with Support

SQL Navigator for Oracle 7.4 - Release Notes

Code Editor PL/SQL

The toolbar appropriate to PL/SQL development opens when you create / open a stored object in the Code Editor. Each of the toolbar icons is described below. In addition, all standard editing functions are available. For more information, see Edit, Compile And Execute.

General Code Editor Functions

Icon Tool Tip Description
Back Navigate between hyperlinked database objects (in the editing pane) and their dependent objects and components.
New SQL Write a single SQL statement or a series of SQL statements in a new editing pane. The toolbar will open for SQL development.
New Stored Object Create a stored object. Open the New Stored Object Dialog.

Open File

Open an external file in the Code Editor.

An alternative way to open file is to drag and drop a file from Windows Explorer to the SQL Navigator window.

Save to File Save the contents of the current Code Editor pane to an external file.
Open Object Locate a stored object using the Select DB Object Dialog and open the object in the editing pane.
Auto Code Completion Turn On/Off Auto Code Completion. When turned on, the Code Editor matches variables, parameters, procedures and types as you type.

Vertical Split

Adjust the layout of the editing pane.

Select from the options to split the editing pane in half either horizontally or vertically. The content of the editing pane will be visible in both panes. You can scroll the panes independent of each other.

TIP: To open a different script in one of the panes:

  1. Open the second script in a new editing pane of the Code Editor.
  2. Return to the split panes. In the pane to load the second script right-click and select Split/Compare | Second Source.
  3. Select the second source from the list of all scripts currently open in the Code Editor.


PL/SQL Specific Functions

Icon Tool Tip Description
Open/Create Package Body Navigate to a function/procedure inside the package body.
  Entry Move the cursor to the function / procedure definition in the code.
Undo all changes Undo all changes since the last save.
Generate DDL script Generate a DDL script of the procedure / function / package. Switch between the DDL script and procedure / function / package using the tabs at the bottom of the screen. While the DDL script is on view the Code Editor toolbar adjusts to editing SQL code.
Save to Database Save changes. Submit the PL/SQL to the database, compile, and report errors
Save to Database As (Clone) Save (clone) the object. The new stored program will have a definition identical to the stored program currently open in the editor. Optionally select a new schema and name for the object.

Execute Procedure / Function

Open the PL/SQL Execution Console from editing mode.

If the PL/SQL Execution Console is already open then execute the code.

TIP: Once you have opened the PL/SQL Execution Console, toggle between execution and editing mode via the tabs at the bottom of the screen.

Stop procedure execution Use if required to stop execution of the procedure before it finishes.
Toggle Breakpoint Add / Remove breakpoint on the selected line of code. For more on debug see PL/SQL Debugger.

PL/SQL Debugger

You can watch the result values during runtime. You can run stored programs in parallel by opening additional sessions within SQL Navigator.

Show/Hide the Toolbox PL/SQL Debugger

Abort Debug Session For more on debug see PL/SQL Debugger.


Team Coding Version Control

To enable Team Coding see Administer Team Coding.

Icon Tool Tip Description

Get Latest Revision

Get the latest version of an object or script as it is held in the Version Control repository.

The Get Latest Revision command overwrites the version of the object or script in the database, replacing it with the latest version held in the VCS repository. You can use the View Differences Dialog to compare versions before overwriting the object.

Check Out

Check out or check in the current object or script.


Check In

Undo Check Out

Cancel the check-out. You are prompted to confirm that you want to discard any changes you have made and restore the database version of the item as it was prior to check-out.

Confirm Yes You have made and saved changes to the object and you want to discard those changes.
Confirm No You have made and saved changes to the object and you want those changes to be retained in the database. As a result the version saved in the third party version control repository will be different from the version saved in the database.


Tools and Applications

Icon Tool Tip Description
SQL Optimizer SQL Optimizer
Explain Plan Explain Plan Tool

PL/SQL Formatter

Format PL/SQL, SQL*Forms, Oracle Forms, and SQL*Plus source code.

Menu Icon Menu Name More Information

Format Text

Format the entire source currently in the editor.

To format just a selection, select the text you want to format.

Output is displayed in the Output Window.

Syntax Check

Check the syntax. Output is displayed in the Output Window.

If syntax errors are detected, the text stays unchanged. The errors are displayed in the Output Window.

Profile Code

Create a summary of the code statistics. You can copy to clipboard or save to file.

Multi-File Formatting

Open the Multi-File Formatting Selection dialog.

  • Select Folder and enter the folder that directly contains the files you want to format. Or
  • Select Files and enter the files you want to format.

Select Backup files to folder to create a backup copy of the files you are about to format.

Format Options

Define how the Formatter Tool formats code.

Formatting Options

Knowledge Xpert Search Knowledge Xpert
Code Analysis Code Analysis


Related Topics

Related Documents

The document was helpful.

Select Rating

I easily found the information I needed.

Select Rating