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;beginfor v_temp in c(30, 'CLERK') loop dbms_output.put_line(v_temp.ename);end loop;end;
页:
[1]