show autocommit : Transaction Rollback Commit « Table « Oracle PL / SQL






  1. Oracle PL / SQL
  2. Table
  3. Transaction Rollback Commit

show autocommit

    

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>








Related examples in the same category

1.Transaction Rollback and commit
2.atomicity: roll back and commit
3.Rollback a delete
4.TRANSACTION CONTROL
5.set transaction use rollback segment SEGMENT_NAME
6.Transactions and Error Handling
7.Transactions and Savepoints
8.SET TRANSACTION READ WRITE
9.Rollback to savepoint in exception handler
10.alter rollback segment SEGMENT_NAME online