17,377
社区成员
发帖
与我相关
我的任务
分享
declare
type newcur is ref cursor;
mycur newcur;
cmd1 varchar2(10);
cmd2 varchar2(10);
cmd3 varchar2(10);
curRow emp%rowtype;
sql1 varchar(200);
begin
cmd1 :='&字段1';
cmd2 :='&字段2';
cmd3 :='&字段3';
sql1 := 'select ' || cmd1 ||' as c1,' || cmd2 ||' as c2,' || cmd3 ||' as c3 from emp';
open mycur for sql1;
loop
fetch mycur into curRow;
exit when mycur%notfound;
dbms_output.put_line(curRow.c1 ||' '||curRow.c2||' '||curRow.c3);
end loop;
end;