Page History

1. Select Preferences > SQL Editor.
   
2. Change the settings as appropriate in each section and then click Apply. 

• Enable the SQL parser...: . For performance reasons, you may want to enable the SQL parser only if a SQL file is smaller than the size you specify here.
• Severity level for semantic validation problems: . Choose a security level from this list.
  This determines how semantic code errors are flagged in the editor and the Problems view.

...

The following describes the options on the Code Assist Preferences page.

• Enable auto-activation: . When selected enables code assist functionality with the Ctrl + Space command. If this option is selected, the code assist window automatically appears when you stop typing.
• Auto-activation delay (ms): . Specify the amount of time in milliseconds that the window automatically appears.
• Auto activation triggers for SQL: . Enter a trigger character or trigger characters. When you enter an activation trigger in the SQL Editor, you will see the code assist options available.
• Fully qualify completions automatically: . When selected, specifies if code completion results are returned specific (fully qualified), rather than the minimum required to identify the object.
• Code assist color options: . Specifies the color formatting of code completion proposals.

...

1. Select Preferences > SQL Editor and then in the Preferences dialog, expand SQL Editor and click Results Viewer.
   
   
2. Make your preference changes and then save your changes by clicking Apply. The following describes the preference options available:

• • Maximum number of result sets: If selected and the executed SQL returns more results sets than the maximum specified, result sets in excess of the maximum specified will not be displayed.
  • Suppress execution messages: If selected and the SQL you execute returns informational messages, they will not be displayed.
  • Show results in editor: Execution results can be either shown in the editor or sent to a file. If you choose
  • Grid refresh interval: Indicates the speed in milliseconds that the Results view refreshes.
  • Maximum result rows to sort: If the number of rows and results exceed this number, the column sorting in the result set is disabled.
  • Results format: These are the different formats that can be used to display the results in the editor.
  • Stripe the rows of the results table: Adds intermittent highlighted bars in the Results view.
  • Display results in separate tab in SQL Editor: Opens the Results view in a separate window on the Workbench.
  • Save results to file: Provides options that let you save the contents of the result sets to a file. You can also specify the file type, delimiter and text qualifier.

Anchor
_SPECIFY_SQL_TEMPLATES _SPECIFY_SQL_TEMPLATES

Specify SQL Templates Preferences

...

1. Select Preferences > SQL Editor and then in the Preferences dialog, expand SQL Editor and click Syntax Coloring.
   
2. Use the tree view provided in the Element window to select the comment type or code element you want to modify. Select the options to the right-hand side of the window to modify it.
   The Preview window shows a piece of sample code that updates according to the changes you made.