Tuesday, September 23, 2008

Deleted Data Stored in Rollback Segments

clear screen
set echo on feedback on heading on pagesize 50

variable emps refcursor

begin
open :emps for
select empno, ename
from emp
where empno > 7800;
end;
/
----------------------------------------------
-- deleted data is saved in a rollback segment
----------------------------------------------
delete from emp;

commit;

print emps

No comments:

Post a Comment