On the move:

I'm currently moving the following to their own blogs: Unix, HTML for Blogs, Perl & Java.
The links are on the left side.

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