You can set orientation, export encoding, affordance in hover, if to continue when an error occurs, and label decorations SQL preferences.
- Select from the main menu bar.
The Preferences dialog opens.
- Expand SQL Development in the left pane and select Execute Plan View Options.
The Execute Plan View Options
dialog appears in the right pane.
- In the SQL Execution Plan View Orientation section, select either Vertical orientation or Horizontal orientation .
Horizontal orientation is the default.
- In the Export Encoding section, select either Default (Cp1252) or Other and select the encoding you want to use from the drop-down list.
- Select General in the left pane.
The General
dialog appears in the right pane displaying settings for database development tooling.
- To disable Show affordance in hover on how to make it sticky, select the check box.
Show affordance in hover on how to make it sticky
is selected by default.
- Select Always, Never, or
Prompt in the Whether to continue when error occurs during SQL execution section.
Prompt is the default.
- Select Label Decorations in the left pane.
The Label Decorations dialog appears in the right pane allowing you to specify the display format for columns in the explorer.
- In the Text section,
click Add Variables to add a variable to the default column format.
The Add Variables dialog opens.
- Select the variable or variables that you want to add and click OK.
The added variable appear in the Column format field and an example appears in the Example field.
- Click OK.
The Preferences dialog closes.