最近有个小项目使用Oracle的存储过程 用到多游标嵌套带参数 记录一下方便以后学习!
在PL/SQL Developer通过了测试!
declare
cursor c_job isselect * from DIVIDEND_FIRST_HALF;
r_job DIVIDEND_FIRST_HALF%rowtype;
cursor c_job2(p_job nvarchar2) is
select * from CALC_DIVIDEND_FIRST_HALF where person_code = p_job;
r_job2 CALC_DIVIDEND_FIRST_HALF%rowtype;
begin
for r_job in c_job loop
for r_job2 in c_job2(r_job.person_code) loop
dbms_output.put_line('员工号 ' || r_job2.person_code || ' ' || '员工姓名 ' ||
r_job2.person_name);
end loop;
end loop;
end;
参考:http://www.cnblogs.com/sc-xx/archive/2011/12/03/2275084.html