我的学习笔记 declare code varchar2(20); danjia varchar2(20); cursor cur is select c.vend_code,c.licence_q from tb_ls75 c where rownum<20; begin open cur; loop fetch cur into code,danjia; DBMS_OUTPUT.put_line(code); exit when cur%notfound; end loop; close cur; end;
declare
code varchar2(20);
danjia varchar2(20);
cursor cur is select c.vend_code,c.licence_q from tb_ls75 c where rownum<20;
begin
open cur;
loop
fetch cur into code,danjia;
DBMS_OUTPUT.put_line(code);
exit when cur%notfound;
end loop;
close cur;
end;