百度出来的例子:
declare
maxrecords constant int:=100;
i int :=1;
begin
for i in 15..maxrecords loop
insert into test (column1, column1, column1,……) values (4, i, 234,……);
end loop;
commit;
end;
WF的例子:
begin
for ii in 1..200000
loop
insert into etltest.source20_key
values(ii,
'AAAAAAAAAAAAAAAAAAAA',
ii,
sysdate,
'AAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAA',
'',
'',
'',
'',
'',
'',
'',
'',
'',
'',
'',
'',
'',
'',
ii
);
if (mod(ii,100)=0) then
commit;
end if;
end loop;
end;
mod(3,4) = 3
mod是取余函数,3除以4结果:商0 余数3
所以mod(3,4)的结果就是3
csdn下载:
declare
i integer;
begin
-- 循环开始
i := 1;
loop
begin
insert into pomer_user
values
(i,'123','123',1,to_date('2011-11-11','yyyy-mm-dd'),'1');
end;
i := i + 1;
-- 跳出循环
if i > 10000000 then
exit;
end if;
end loop;
commit;
end;
转载于:https://blog.51cto.com/suexiukjung/1135657