oracle批量插入数据
create or replace procedure AAA is
begin
declare
maxnumber constant int:=2000000;
i int :=1;
begin
for i in 1..maxnumber loop
insert into t_tjfx_czrk_jmsfztj (cjsj,sqfj,cjfj,slyy,sl,ydblbz,dqhjzt,dqywhj,tjsj,gxsj)
values(sysdate-1,’440100000000’,’440100000000’,’12’,1,’1’,’已处理’,’领取发放’,sysdate,sysdate-1);
end loop;
dbms_output.put_line(’ 成功录入数据! ‘);
commit;
end;
end AAA;