Name

AUTOCOMMIT

Synopsis

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

Controls when Oracle commits pending changes to the database.

OFF

Suppresses automatic committing, forcing you to commit changes manually.

ON

Commits pending changes to the database after Oracle executes each successful SQL command or PL/SQL block.

IMMEDIATE

Functions the same way as ON.

n

Commits after performing n successful SQL commands or PL/SQL blocks.

..................Content has been hidden....................

You can't read the all page of ebook, please click here login for view all page.
Reset