demo02.sql

来自「Expert Oracle Database Architecture 9i a」· SQL 代码 · 共 21 行

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