PL⼀SQL代码实现 向任意1张表添加1W条记录?

2025-03-24 04:53:23
推荐回答(1个)
回答1:

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;