oracle定义游标cursor遍历sql查询结果,通过dbms_output.put_line在output输出
declare
cursor x is
with
v1 as (select * from 表名 where rownum<11)
select * from v1;
begin
for y in x loop
dbms_output.put_line (y.字段名);
end loop;
end;
declare
cursor subId is select * from 表名 where rownum <11;
begin
for y in subId loop
dbms_output.put_line (‘员工的ID是:’||y.subs_id);
end loop;
end;