Formatting Options
Configure how the Formatter Tool formats code. Formatter Tools are available from the Tools Menu.
Formatting Options Toolbar
| Icon | Tool Tip | Description | ||
|---|---|---|---|---|
 |
Open | Open a previously saved file of SQL Navigator formatting options. | ||
 |
Save |
Save the currently selected formatting options to the SQL Navigator installation folder, filename FmtOptions.opt.
| ||
 |
Reset Pane to Recommended Defaults | Reset the Formatting Options to the default values |
|
|
TIP: SQL Navigator loads the Formatting Options from the default file (FmtOptions.opt) and default location each time the Formatting Tool Options window is opened and when the Formatter Tool performs formatting. The default location for Formatting Options is in the SQL Navigator installation folder. |
Set formatting options
| Category | Options in the Category |
|---|---|
|
Oracle Formatter Options |
Tooltips Show tooltips when the mouse cursor is hovered over certain options. Copy Options to Clipboard Copy the options in both INI and XML format to clipboard for backup or reviewing purposes. Show the Example Window Show an example window when navigating different pages of the Formatter Options window. You can specify a script file to be formatted as an example, or select the Document per Pane option to use the example scripts from the Example document folder. You can modify the example scripts in the Example window. Changes are saved automatically. |
|
Header |
Select Enable to generate a header tagline after formatting the script. You can specify some text to be included in the header tagline. Do not use /* or */ in the text. Note: The date time options are currently not in use. |
|
Spacing |
Set physical output characteristics such as tab size, margins, and indents. |
|
Comments |
Select this option to align trailing comments to the right margin. |
|
Case |
Modify the lowercase, uppercase, or initial capitals of various syntax elements. |
|
Operators & Punctuations |
Specify the behavior of various operators and punctuations. |
|
Alignments |
Set alignments of various syntax elements. |
|
List Arrangements |
Define list attributes such as parentheses, commas and folding/stacking characteristics. |