Chat now with support
Chat with Support

SQL Navigator for Oracle 7.4 - Release Notes

Code Editor | General



Option Description
Find Text at Cursor Automatically place the word at the current cursor position into the Find box.
Font The font used in the Code Editor window.

Code Convention Lowercase

Paste objects in lower case into the editor. Also affects column names in the drop down list as part of code completion in any of the text editors, as upper or lower case, when you type in a table name with the '.' operator.

The preference was previously known as Drag and Drop Objects to Lowercase.

Auto Indent Position the cursor under the first nonblank character of the preceding nonblank line when user presses Enter.

Indent Size

Indent Size used when Indenting selected text using CTRL + I.

Not applicable if Use TAB Characters is selected.

Use TAB Characters

Selected Insert tab characters.
Not Selected Insert space characters.

If Smart TAB is selected this option is off.

Tab Size The horizontal width of the Tab space in number of characters.

Smart Tab

Tab to the first character in the preceding line.

If Use TAB Characters is selected this option is off.

Smart Fill Begins every auto-indented line with the minimum number of characters possible, using tabs and spaces as necessary.
Keywords to Uppercase Convert all keywords to uppercase as they are typed into the editor.

Syntax highlighting

Enable the highlighting of syntax within the editor.

Option Description
Highlighting Style Default Styles with color schemes for syntax highlighting.
Colors Set a custom style for syntax highlighting. Also set the highlighting style to custom.

Column Track

When selected the cursor "remembers" its starting column position and moves to the same position when you move it up or down to a new line.

Use together with Allow Caret after EOL.

Hot Links When selected the user can open an object from the SQL text via Ctrl+Click.

Allow Caret after EOL


The user can move the cursor beyond the end of the current line. The cursor’s vertical movement ignores the EOL position of the line current line.

Use together with Column Track.

Not Selected

The user cannot move the cursor beyond the end of the current line. The cursor’s vertical movement is constrained by the EOL position of each line.

Show Line Numbers Show line numbers in the Code Editor.

Show Right Margin

When selected, draw a vertical line in your editing window representing the right-hand page boundary.

Option Description
Right Margin Width Placement is controlled by the Right Margin Width setting.


Open the Code Shortcuts And Templates Dialog.

Create, edit, or delete templates.

Describe Object at Hyperlink When selected, open the Describe window (Describe) when press Ctrl and right-click on an object name and create a hyperlink.
Highlight Current Line When selected, the line containing the cursor is highlighted.
Allow Tab Items to Expand onto Multiple Lines Display Tab items on multiple lines if the current line is full. Select for ease of navigating through multiple open PL/SQL objects and SQL queries.

Enable Code Collapsing

Related to: Edit, Compile And Execute

When selected, the Code Collapsing functionality is turned on allowing the user to collapse/expand blocks of code.

Option Description
Disable Code Collapsing when line count exceeds When a script/object exceeds the specified number of lines, Code Collapsing is disabled to improve performance.
Save successfully executed sql in the History tool Select to save a copy of successfully executed queries in C:\Documents and Settings\<username>\Application Data\Quest Software\SQL Navigator\Unified Editor\history.
Turn Off Variable Hints Select turn off the pop up hints that are displayed when you hover the mouse over function or procedure names, or variables.
Scan Defines/Substitutions Related to: Scan Defines/Substitutions
Sub-tab row location Specify the position of the sub-tab to be displayed.
Close Code Editor when last tab closes When selected, the Code Editor closes when the last tab in the editor is closed.


Related Topics

Related Documents

The document was helpful.

Select Rating

I easily found the information I needed.

Select Rating