Oracle几种游标的写法

第一种方式：

declare
lv_deptno emp.deptno % type: = 10 ;
lv_ename emp.ENAME % type: = '' ;
cursor find_emps_bydeptno(v_deptno number) is select ename from emp where deptno = v_deptno;
begin
open find_emps_bydeptno(lv_deptno);
loop
fetch find_emps_bydeptno into lv_ename;
exit when find_emps_bydeptno % notfound;
dbms_output.put_line( ' name: ' || lv_ename);
end loop;
close find_emps_bydeptno;
end;

第二种方式：

declare
lv_deptno emp.deptno % type: = 10 ;
cursor find_emps_bydeptno(v_deptno number) is select ename from emp where deptno = v_deptno;
begin
for v_obj in find_emps_bydeptno(lv_deptno)
loop
dbms_output.put_line( ' name: ' || v_obj.ename);
end loop;
end;

第三种方式：

declare
lv_deptno emp.deptno % type: = 10 ;
begin
for v_obj in (select ename from emp where deptno = lv_deptno)
loop
dbms_output.put_line( ' name: ' || v_obj.ename);
end loop;
end;

转载于:https://www.cnblogs.com/yerenno1/articles/2059449.html