AUTOCOMMIT
AUTO[COMMIT] {OFF | ON | IMM[EDIATE] | n
}
Controls when Oracle commits pending changes to the database.
Suppresses automatic committing, forcing you to commit changes manually.
Commits pending changes to the database after Oracle executes each successful SQL command or PL/SQL block.
Functions the same way as ON.
Commits after performing n successful SQL commands or PL/SQL blocks.