[Oracle]-[implicit commit]-functions of normal and abnormal exit on commit

[Oracle]-[implicit commit]-functions of normal and abnormal exit on 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: Log On again. select count (*) from my_objects; COUNT (*) ---------- 0 Description: If sqlplus is exited normally (if exit is used), commit is executed; if you use alter system kill session 'sid, serial # 'to exit sqlplus with an exception, rollback will be executed.