Oracle Sqlplus SET AUTOCOMMIT

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.

（编辑：李大同）

【声明】本站内容均来自网络，其相关言论仅代表作者个人观点，不代表本站立场。若无意侵犯到您的权利，请及时与联系站长删除相关内容!