The following options let you select when to commit changes to the database. You can also commit manually by entering an explicit COMMIT statement whenever appropriate.

Commit after every statement   Select this option to commit changes to the database after each SQL statement is executed.

Commit on exit or disconnect   Select this option to commit changes to the database when you exit your Interactive SQL session. This is the default.

See auto_commit option [Interactive SQL].