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

goinglw

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;