Setting SQL Development Preferences

Set SQL Development preferences for label decorations, execution plans, SQL Editor, SQL Query Builder, and SQL Results view.

1. Select Window > Preferences from the main menu bar.
2. In the left pane, under Data Management, expand SQL Development.

• Execution Plan View Options Preferences
  Set execution plan view options to specify defaults for viewing query plans.
• Database Development General Preferences
  The general user preferences concern executing and debugging procedural objects.
• SQL Query Builder Preferences
  Indicate the SQL Query Builder preferences.