1、forFOR num IN 1..10000 LOOP
insert into table_name values(....);
IF mod(num,1000)=0 THEN
commit;
END IF;END LOOP;commit;2、loopnum:=0;loopexit when num>10000;insert into table_name values(....); num := num + 1;
IF mod(num,1000)=0 THEN
commit;
END I...
