Setting SQL Editor Preferences

You can change the behavior of the SQL Editor.

  1. Select Window > Preferences from the main menu bar.

    The Preferences dialog opens.

  2. Expand SQL Development and select SQL Editor.

    The SQL Editor dialog appears in the right pane displaying General and Typing tabs.

  3. In the General tab, to show line numbers, select the Show line numbers check box.

    This is checked by default.

  4. In the Syntax validation section of the General tab, change any of the following:
    • To enable syntax validation, select the Enable syntax validation check box.

      This is checked by default.

    • Click the down arrow in the Portability check target field and make a selection.

      The default is None.

    • To specify a maximum number of lines, select the Maximum number lines check box and type the number of lines the text box.

      This is checked by default and the default number of lines is 1000.

    • To prompt to disable syntax when a maximum number of lines is exceeded, select the Prompt to disable syntax validation when content exceeds maximum number of lines check box.

      This is checked by default.

  5. Select the Typing tab.

    A list of typing aids that are enabled in Smart Insert mode is displayed.

  6. Deselect typing aids that you do not want to use.
  7. Select an aid in the table to see the code in the Preview box.
  8. Click OK.
Related concepts
SQL Editor
SQL Files
Content Assist
Database Development Perspective
Related reference
SQL Editor Preferences
Database Development Preferences