1、for
FOR num IN 1..10000 LOOP
insert into table_name values(....);
IF mod(num,1000)=0 THEN
commit;
END IF;
END LOOP;
commit;
2、loop
num:=0;
loop
exit when num>10000;
insert into table_name values(....);
num := num + 1;
IF mod(num,1000)=0 THEN
commit;
END IF;
END LOOP;
commit;
3、while
num:=0;
WHILE (num<=10000) LOOP
insert into table_name values(....);
num := num + 1;
IF mod(num,1000)=0 THEN
commit;
END IF;
END LOOP;