Versions Compared

Old Version 2

changes.mady.by.user Nadja Pollard

Saved on

compared with

New Version 3

changes.mady.by.user Nadja Pollard

Saved on

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

The SQL Execution preferences you set determine how SQL is executed.

Select Preferences > SQL Execution. Image Removed

Image Added

The following describes the SQL Execution Preference options available.

  • Enableauto-commitforthefollowing platforms: When disabled, the SQL is executed within transactions that must be manually committed.
  • EnableDBMSoutput(Oracleonly): When disabled, this omits the output statements that

...

  • Oracle would otherwise display. 
Info

...

If you disable auto-commit for a platform, you must use SQL Editor's transaction features to execute code on that platform.