declare
v_sql varchar2(500):=&请你输入;
p_cursor datatype.P_cursor;
begin
v_sql:='select * from (select A.*,rownum r_id from ('||v_sql||') A where rownum<=5) B where B.r_id>=1';
dbms_output.put_line(v_sql);
open p_cursor for v_sql;
for i in p_cursor
loop
dbms_output.put_line(i.deptno||'---'||i.dname||'---'||i.loc);
end loop;
end;
v_sql varchar2(500):=&请你输入;
p_cursor datatype.P_cursor;
begin
v_sql:='select * from (select A.*,rownum r_id from ('||v_sql||') A where rownum<=5) B where B.r_id>=1';
dbms_output.put_line(v_sql);
open p_cursor for v_sql;
for i in p_cursor
loop
dbms_output.put_line(i.deptno||'---'||i.dname||'---'||i.loc);
end loop;
end;
试试下面的plsql:declare
type refcursor is ref cursor;
p_cursor refcursor;
l_deptno varchar2(200);
l_dname varchar2(200);
l_loc varchar2(200);
v_sql varchar2(500) := '&请你输入';
begin
v_sql := 'select deptno,dname,loc from (select A.*,rownum r_id from (' || v_sql ||
') A where rownum <=5) B where B.r_id>=1';
dbms_output.put_line(v_sql);
open p_cursor for v_sql;
loop
fetch p_cursor
into l_deptno,l_dname,l_loc;
exit when p_cursor%notfound;
dbms_output.put_line(l_deptno || '---' || l_dname || '---' || l_loc);
end loop;
end;
/
v_sql varchar2(500):=&请你输入;
p_cursor datatype.P_cursor;
begin
v_sql:='select * from (select A.*,rownum r_id from (' ¦ ¦v_sql ¦ ¦') A where rownum <=5) B where B.r_id>=1';
dbms_output.put_line(v_sql);
open p_cursor for v_sql;
for i in p_cursor
loop
dbms_output.put_line(i.deptno ¦ ¦'---' ¦ ¦i.dname ¦ ¦'---' ¦ ¦i.loc);
end loop;
end;
&请你输入需要更改成'&请你输入'