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 |
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.
| ||||||
|
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 |
| ||||||
| 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.
| ||||||
|
Templates |
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.
| ||||||
| 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. |