Oracle PL/SQL Tutorial/SQL PLUS Session Environment/autocommit

Show and set autocommit

   <source lang="sql">

SQL> SQL> SQL> set autocommit on SQL> show autocommit autocommit IMMEDIATE SQL> set autocommit 42 SQL> show autocommit AUTOCOMMIT ON for every 42 DML statements SQL> set autocommit off SQL> SQL></source>