--循环插入120000次数据
declare
p_sql varchar2(500);
i number;
begin
i:=0;
WHILE(i<12000) LOOP
p_sql:= 'insert into et_busiform_tb
select * from et_busiform_tb where work_date in(''20150505'',''20150505'',''20150429'',''20150429'')';
i:=i+1;
execute immediate p_sql;
commit;
end loop;
end;