oracle的版本:
Oracle Database 10g Enterprise Edition Release 10.2.0.1.0 - Prod
在同一个sqlplus窗口中切换用户时,conn会触发commit,如下:
SQL> conn scott/tiger
Connected.
SQL> select * from t;
X
----------
1
1
1
1
SQL> insert into t select * from t;
4 rows created.
SQL> conn sys/oracle as sysdba
Connected.
SQL> select * from scott.t;
X
----------
1
1
1
1
1
1
1
1
8 rows selected.
SQL>
来自 “ ITPUB博客 ” ,链接:http://blog.itpub.net/14348903/viewspace-696797/,如需转载,请注明出处,否则将追究法律责任。
转载于:http://blog.itpub.net/14348903/viewspace-696797/