demo02.sql

Expert Oracle Database Architecture 9i and 10g sql源码

drop table t;

create table t
as
select *
  from all_users;
 
variable x refcursor

begin
   open :x for select * from t;
end;
/
 
delete from t;
 
commit;
 
print x