17PL_SQL过程之带参数的游标

declare
  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;