oracle 利用bulk collect into 批量insert

以下为9i中实现的过程declare type t_rn is table of tmp.rn%type index by binary_integer; type t_ran is table of tmp.num%type index by binary_integer; rn t_rn; ran t_ran; cursor cur_num is select rownum, trunc(dbms_random.value,2) * 100 from dual connect by rownum <= 100000;begin dbms_output.put_line(to_char(sysdate, 'yyyy-mm-dd hh24:mi:ss')); open cur_num; loop fetch cur_num bulk collect into rn, ran limit 5000; for i in 1 .. rn.count loop insert into tmp values (rn(i), ran(i)); commit; end loop; exit when cur_num%notfound; end loop; close cur_num; dbms_output.put_line(to_char(sysdate, 'yyyy-mm-dd hh24:mi:ss'));end;

还有10g实现的过程