【Oracle】-【隐式commit】-正常與異常退出對commit的作用

create table my_objects as select * from all_objects;

commit;

select count(*) from my_objects;

  COUNT(*)

----------

      8587

delete from my_objects;

8587 rows deleted.

exit

再次登入，

說明：

正常退出sqlplus（如用exit）,會執行commit;

異常退出sqlplus(如用alter system kill session 'sid,serial#'),會執行rollback。