
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