plsq程序设计--带参数的游标

declare
--c(两个参数)
  cursor c(v_deptno emp.deptno%type, v_job emp.job%type)
  is
  --为两个参数赋值
         select ename, sal from emp where deptno = v_deptno and job = v_job;
  --v_temp c%rowtype;
begin
  for v_temp in c(30, 'CLERK') loop
      dbms_output.put_line(v_temp.ename);
  end loop;
end;