AUTOCOMMIT
AUTO[COMMIT] {ON | OFF | IMM[EDIATE] | n} 

Controls when Oracle commits pending changes to the database.

Keywords

ON

Commits pending changes to the database after each successful SQL statement or PL/SQL block is executed.

OFF

Suppresses automatic committing so that you must commit changes manually. This option is the default.

IMMEDIATE

Functions the same as ON.

n

Commits after every n successful SQL statements or PL/SQL blocks.

Get Oracle SQL: the Essential Reference now with O’Reilly online learning.

O’Reilly members experience live online training, plus books, videos, and digital content from 200+ publishers.