游标的基本使用

select DTID,FLD_ID,D1_DATE,D1_VAL
    from RICK.T_RPT_DATA1 where FLD_ID in (1,2,3);

----------------游标的基本使用
declare
   ----1,声明游标
   cursor mycursor is
     select * from  T_RPT_DATA1 where FLD_ID in (1,2,3);

   vtmpRow T_RPT_DATA1%rowType;
   vMaxRow number;
begin
   select count(*) into vMaxRow from  T_RPT_DATA1 where FLD_ID in (1,2,3);
  
   ----2.打开游标
    open   mycursor;

  ----3.循环【for loop】迭代游标
    for i in 1..vMaxRow loop
      ---3.1，抓取游标数据
      fetch mycursor into vtmpRow;
      update T_RPT_DATA1 set
         D1_VAL=D1_VAL+i where DTID=vtmpRow.DTID;
    end loop;

    commit;
  ----4.关闭游标
    close mycursor;

end;