Chat now with support
Chat with Support

SQL Navigator for Oracle 7.4 - Installation Notes

Code Editor | SQL Scripts

SQL Scripts

Option Description

Spool Output

When selected, returned results are sent to the spool pane (SQL Query Log (The Spool Tab)) of the Code Editor on query execution.

This option does not turn on/off the Spool option of the existing code editor tabs.

Option Description
Default Rows Displayed Specifies how many rows of returned results are sent to the spool pane of the Code Editor on query execution when Fetch All is set to OFF.
Bring to front after execution When selected, the Spool tab is shown on top after the execution of a PL/SQL block.

Split Window to Display Results
Selected The data grid is shown below the script tab.
Not Selected The data grid is shown in a whole window.

Fetch All
Selected Retrieve all results and display in the data grid.
Not Selected Retrieve the number of rows that can be displayed in the data grid. Scroll down the grid to retrieve more rows.

Show Errors in Output Window
Selected Show a brief error message in the Execution Status pane below the editing area. Show detailed error messages in the Output Window.
Not Selected Show a brief error message in the Execution Status pane only.
Retrieve all result fields as strings When selected, this option causes all numeric fields to be converted to strings on the server.
Use Table Alias Select to use table aliases in the SQL statements generated by Quick Browse and Edit Data.
Cursor focus stays in the SQL query after single execution When selected, the cursor will stay in the Script area instead of moving to the data grid.
Highlight query for corresponding data result When selected, the SQL that has been executed, and corresponds to the data shown in the data grid, is highlighted.
Focus query for corresponding data result When selected, the cursor will stay in the Script area instead of moving to the data grid.

Allow session switching
Selected You can switch sessions for an open editor. This means you can easily run the same SQL statement(s) against multiple databases.
Not Selected You will need to open multiple editing windows to accomplish this task.

Code Completion

Option Description
Delay (milliseconds)  

Automatic Code Completion

When selected,a ‘pick’ list of matching symbols (variables, parameters, procedures, types) in the current scope is displayed when you start typing in an identifier.

When selected, it will also include Automatic Dot-Lookup.

Automatic Dot Lookup

when selected, a ‘pick’ list of members of a PL/SQL record, cursor, package or %ROWTYPE record are displayed when you type a dot character after a name of variable.

Automatic Dot Lookup can be selected as a stand-alone option.

Drag & Drop

Option Description

Drag & Drop of Tables or Views nodes

Specifies what will be inserted when a table node is dragged and dropped from DB Explorer into the Code Editor.

If this preference is set to insert a query statement for each table, using Ctrl or Shift key while drag and drop will not have any effect on the format of the queries.

Drag and Drop arguments with code objects

When selected, drag & drop code objects (such as procedure, function) will include their arguments (such as Input parameters, Output parameters)

Code Analysis

Module: Code Analysis

Option Description
Embed Code Analysis in editor windows When selected, a Code Analysis tab appears in the editor window next to the Code tab which you can open as required.
Related Documents

The document was helpful.

Select Rating

I easily found the information I needed.

Select Rating