用游标嘛:create or replace procedure xxx(po_cursorout sys_refcursor) is
begin
...
open po_cursor for select ... from a, b, c where a.xx = b.xx and a.xxx=c.xxx;
....
end;
dageji111 发表于 2012-3-5 16:44
用游标嘛:create or replace procedure xxx(po_cursorout sys_refcursor) is
begin
...
如果我有多个结果集是根据参数查询出来的,然后我再根据查询后的结果进行表关联,这样用游标能实现?