The Options dialog has the following components:
Display Null Values As A string that is displayed in the results pane to represent NULL values in the result set.
Fetching Data You can specify a length (number of bytes) at which to truncate long column values for better performance.
Automatic Commit Choose whether to automatically execute a COMMIT statement after each statement or only on exiting the application. If you choose to COMMIT only on exiting the application, changes you make to the database are not permanent until you either enter an explicit COMMIT statement or exit the application.
Plan Display Choose whether to display the query plan graphically or in text format.
The text version can be difficult to interpret but is useful for pasting into other applications. The graphical version is easier to interpret.
For more information on query plans, see .