带参数的游标
Oracle,plsql编程
–以scott用户登录案例库,通过游标,循环输出某个部门员工信息(员工编号、员工名字、薪水)
declare
cursor p(v_deptno emp.deptno%type) is select empno,ename,sal from emp where deptno=v_deptno;
v_empno emp.empno%type;
v_ename emp.ename%type;
v_sal emp.sal%type;
begin
open p(20); --此处打开的是20号部门
fetch p into v_empno,v_ename,v_sal;
while p%FOUND loop
dbms_output.put_line(v_empno||','||v_ename||','||v_sal);
fetch p into v_empno,v_ename,v_sal;
end loop;
close p;
end;