plsq程序设计--带参数的游标
程序员文章站
2022-06-05 09:00:51
...
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;
上一篇: java AES对称加密解密
下一篇: plsq程序设计--游标