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
再次登录，
select count(*) from my_objects;
COUNT(*)
----------
commit;
select count(*) from my_objects;
COUNT(*)
----------
8587
delete from my_objects;
8587 rows deleted.
exit
再次登录，
select count(*) from my_objects;
COUNT(*)
----------
0
说明：
正常退出sqlplus（如用exit）,会执行commit;
异常退出sqlplus(如用alter system kill session 'sid,serial#'),会执行rollback。
来自 “ ITPUB博客 ” ，链接：https://blog.itpub.net/7192724/viewspace-767160/ ，如需转载，请注明出处，否则将追究法律责任。
请登录后发表评论
登录
全部评论
