pl/sql入门-带参数的光标

带参数的光标--查询10号部门的员工

set serveroutput on

declare

    --带参数的光标
   cursor cemp (dno number) is select ename from emp where deptno=dno;
    pename emp.ename%type;

begin
    open cemp('10');

    loop
        fetch cemp into pename;
        exit when cemp%notfound;

        dbms_output.put_line(pename);

    end loop;
    
    close cemp;
end;
/