带参数的光标

  --带参数的光标
      --查询某个部门中员工的姓名
     declare
     cursor cemp(dno number) is select ename from emp where deptno=dno;
     pename emp.ename%type;
     begin
        open cemp(20);
        loop
        fetch cemp into pename;
        exit when cemp%notfound;
        DBMS_OUTPUT.PUT_LINE(pename);
        end loop;
        close cemp;
        end;