给你个例子declare -- Local variables here i integer:=0; Begin -- Test statements here For i In 1.. 10 LOOP INSERT INTO tbname --tbname表名 ( AA001, --VARCHAR2(14) 流水号 AA002) --VARCHAR2(14) 名称
VALUES ( i+12345678, 测试||i) ; End Loop; --Return; End; /
3楼的哥们写的很好 Create Or Replace Procedure mm( i_Aggr in number, i_Agpa in number, i_sAgenID in number, i_eAgenID in number) As n_cnt number;
Begin for n_cnt in i_sAgenID..i_eAgenID Loop begin insert into table(aa,bb,cc,dd,ee,ff,gg,hh,ii,jj,kk,ll) values(n_cnt,i_Aggr,i_Agpa,1,'ID'||to_char(n_cnt),'ID'||to_char(n_cnt),to_char(n_cnt), 1,4,1,1,1); end; End Loop; Commit; End; exec mm(100,101,5201,5500);
select values from tables
for(;;)
把 insert 嵌入到循环体里,就可以实现批量数据插入了。
-- Local variables here
i integer:=0;
Begin
-- Test statements here
For i In 1.. 10 LOOP
INSERT INTO tbname --tbname表名
( AA001, --VARCHAR2(14) 流水号
AA002) --VARCHAR2(14) 名称
VALUES
( i+12345678,
测试||i) ;
End Loop;
--Return;
End;
/
i_Aggr in number,
i_Agpa in number,
i_sAgenID in number,
i_eAgenID in number)
As
n_cnt number;
Begin for n_cnt in i_sAgenID..i_eAgenID Loop
begin
insert into table(aa,bb,cc,dd,ee,ff,gg,hh,ii,jj,kk,ll)
values(n_cnt,i_Aggr,i_Agpa,1,'ID'||to_char(n_cnt),'ID'||to_char(n_cnt),to_char(n_cnt),
1,4,1,1,1);
end;
End Loop;
Commit;
End;
exec mm(100,101,5201,5500);