The SQL Execution preferences you set determine how SQL is executed.
To specify SQL Execution preferences
- Select Preferences > SQL Execution.
- Select from the following options, and then click OK.
- Enable auto-commit for the following platforms: When disabled, the SQL is executed within transactions that must be manually committed.
- Enable DBMS output (Oracle only): When disabled, this omits the output statements that Oracle would otherwise display.
If you disable auto-commit for a platform, you must use SQL Editor's transaction features to execute code on that platform.