oracle游标loop总结

2019独角兽企业重金招聘Python工程师标准>>>

1、%notfound：

v_empno number;

declare

cursor c_emp is

select empNo from emp;

begin

open c_emp

loop

fetch c_emp into v_empno;

exit when c_emp%notfound;

dbms_output.put_line(v_empno);

end loop;

close c_emp;

end;

这里loop要写在fetch前面

2、%found:

v_empno number;

declare

cursor c_emp is

select empNo from emp;

begin

open c_emp

fetch c_emp into v_empno;

while c_emp%found loop

  dbms_output.put_line(v_empno);

  fetch c_emp into v_empno;

end loop;

close c_emp;

end;

loop需写在fetch ... into ...语句之后，且loop循环中还需要再使用fetch ... into ... 语句，读取下一条记录

转载于:https://my.oschina.net/maoguangdong/blog/740429