===========================================================
动态游标的操作~~~
===========================================================
作者: junsansi(http://junsansi.itpub.net)
发表于:2007.04.05 11:11
分类: 三思笔记
出处：http://junsansi.itpub.net/post/29894/277522
---------------------------------------------------------------
发表于:2007.04.05 11:11
分类: 三思笔记
出处：http://junsansi.itpub.net/post/29894/277522
---------------------------------------------------------------
--方法1
declare
cursor tmp_cur(tmp_num NUMBER) IS select * from tables where part_num=tmpnum;
begin
for emp_record in tmp_cur(123) loop
.......
.......
end loop;
end;
--方法2
declare
begin
for emp_record in (select * from tables where part_num=123) loop
.......
.......
end loop;
end;