Name

SET AUTOCOMMIT

Synopsis

The AUTOCOMMIT setting controls whether sql*Plus automatically commits changes you make to the database,and it controls how often those changes are committed.

Syntax SET AUTO[COMMIT] {OFF | ON | IMMEDIATE | statement_count}

另外实际发现：对于create table and drop table 是无法rollback的

只有像insert才可以rollback.

sql> create table temp_test as select * from it;

Table created.

sql> show auto
autocommit OFF
sql> rollback;

Rollback complete.

sql> drop table temp_test;

Table dropped.

sql> create table temp_test as select * from it;

Table created.

sql> insert into temp_test select * from it;

4 rows created.

sql> commit;

Commit complete.