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

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

create or replace procedure REGION_SENDER_INSERT
is
begin
  Execute IMMEDIATE 'TRUNCATE TABLE region_sender_stat ';
  declare 
  cursor c1 is select REGION_ID from REGION;
  v_region_id nvarchar2(16);
/*  v_sender_num Number:=0;*/
  begin
    open c1;--打开游标
    fetch c1 into v_region_id;
    while c1 % found loop  
      insert into region_sender_stat(REGION_ID) values (v_region_id);--将区域的id插入到统计表中
      fetch c1 into v_region_id;
    end loop;
    close c1;--关闭游标
  end;
    commit;
end REGION_SENDER_INSERT;