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;
plsq程序设计--带参数的游标
最新推荐文章于 2022-05-20 09:35:46 发布