oracle+循环插入sql,sql oracle循环插入数据

SELECT count(1) FROM "SHB"."STATIS_JFJL_COPY";

select *

from "SHB"."STATIS_JFJL_COPY"

truncate table "SHB"."STATIS_JFJL_COPY"

declare

maxnumber constant int:=10000;

i int :=1;

begin

for i in 1..maxnumber loop

insert into "SHB"."STATIS_JFJL_COPY"("HID_","TYPEID_",SUMMONEY_,MONTH_,TYPENAME_,AREACODE_)

values(i,'1','100','1','高区','001');

end loop;

dbms_output.put_line(' 成功录入数据！ ');

commit;

end;

select SUMMONEY_,AREACODE_

from "SHB"."STATIS_JFJL_COPY"

where 1=1 and TYPEID_='1' and MONTH_='1'

在添加个简单例子

declare

maxnumber constant int:=2000000;

i int :=1;

begin

for i in 1..maxnumber loop

-- insert into "SHB"."STATIS_JFJL_COPY"("HID_","TYPEID_",SUMMONEY_,MONTH_,TYPENAME_,AREACODE_)

-- values(i,'1','100','1','高区','001');

INSERT INTO ENERGY.WATER_METER_DATA(HID,METER_ID,IN_FLOW,OUT_FLOW,FLOW_SPEED,IN_TEMPERATURE,ALL_WORK_TIME,ALL_TIME,SYS_READ_TIME,RUNNING_STATE,NOTES,MEMO1,MEMO2,MEMO3,MEMO4,MEMO5,MEMO6,CREATE_DATE,CREATE_USER,UPDATE_DATE,UPDATE_USER)

VALUES(i,'60','234','12','2','12','12小时','12小时',TO_DATE('2016-01-02','yyyy-mm-dd'),'501','','','','','','','',TO_DATE('2016-01-02','yyyy-mm-dd'),'张三',TO_DATE('2016-01-02','yyyy-mm-dd'),'张三');

end loop;

dbms_output.put_line(' 成功录入数据！ ');

commit;

end;