open cur_a loop fectch cur_a into rec_a; exit when cur_a%notfound; --嵌套 open cur_b loop ... end loop; close cur_b; end loop; close cur_a;
呵呵,来晚了。 open cur_a loop fectch cur_a into rec_a; exit when cur_a%notfound; --嵌套 open cur_b loop fectch cur_b into rec_b; exit when cur_a%notfound; ... end loop; close cur_b; end loop; close cur_a;
loop
fectch cur_a into rec_a;
exit when cur_a%notfound;
--嵌套
open cur_b
loop
...
end loop;
close cur_b;
end loop;
close cur_a;
open cur_a
loop
fectch cur_a into rec_a;
exit when cur_a%notfound;
--嵌套
open cur_b
loop
fectch cur_b into rec_b;
exit when cur_a%notfound;
...
end loop;
close cur_b;
end loop;
close cur_a;