Oracle PL/SQL编程学习笔记：游标

游标参考：http://www.cnblogs.com/sc-xx/archive/2011/12/03/2275084.html

 1 create or replace procedure REGION_SENDER_INSERT
 2 is
 3 begin
 4   Execute IMMEDIATE 'TRUNCATE TABLE region_sender_stat ';
 5   declare 
 6   cursor c1 is select REGION_ID from REGION;
 7   v_region_id nvarchar2(16);
 8 /*  v_sender_num Number:=0;*/
 9   begin
10     open c1;--打开游标
11     fetch c1 into v_region_id;
12     while c1 % found loop  
13       insert into region_sender_stat(REGION_ID) values (v_region_id);--将区域的id插入到统计表中
14       fetch c1 into v_region_id;
15     end loop;
16     close c1;--关闭游标
17   end;
18     commit;
19 end REGION_SENDER_INSERT;

posted @ 2012-11-26 17:28  太一吾鱼水  阅读(202)  评论(0)  编辑  收藏  举报