declare i integer;
begin i:=1;
loop
insert into IM_T_AISA_AUDIT (AISA_ID, AISA_NAME, AISA_TYPE, AISA_COMPLETE_DATE, AISA_SHIGONG_UNIT, AISA_SONGSHEN_UNIT, AISA_IDEA, AISA_CREATE_UNIT, AISA_CREATE_DATE, SYN_YEAR, SYN_MONTH, HOLD_COLUMNS1, HOLD_COLUMNS2, HOLD_COLUMNS3, HOLD_COLUMNS4, WEBSITE_ID, CREATE_USER_ID, COMPANY_ID, CREATE_DATE, UPDATE_USER_ID, UPDATE_DATE, IS_UP)
values (SEQ_DD_T_DISCOURSE.Nextval, '电站',1, to_date('20-07-2005', 'dd-mm-yyyy'), '农电科', 19.9, '核减17800元', '140000000000000590', to_date('20-12-2007', 'dd-mm-yyyy'), 0, 0, null, null, 0, 0, 14, 'QKW|14', '140000000000000590', to_date('20-12-2007', 'dd-mm-yyyy'), 'QKW|14', to_date('20-12-2007', 'dd-mm-yyyy'), 0);
i:=i+1;
exit when i>50000;
end loop;
commit;
end;
/
方法二
begin
for i in 1..1000 loop
insert into test values(col1,col2,col3....);
end loop;
end;
/