oracle数组的使用

declare

  type type_array is varray(192) of varchar2(80);

  number_array type_array := type_array('20120201_W04061302'

                                        );

  id_array type_array := type_array('zyMBBwE1EADgMBB1wKgCy49SAK4=');

begin

  for i in 1 .. number_array.count() loop

    update deppon2011.CT_DLS_DepArDayRptArrive rpt

       set rpt.cforiginalrptid = id_array(i)

     where rpt.fnumber = number_array(i)

       and rpt.ffivouchered = 0

       and rpt.fbizdate >= to_date('2012-02-01', 'yyyy-mm-dd')

       and rpt.cfenddate < to_date('2012-03-01', 'yyyy-mm-dd');

    commit;

  end loop;

end;