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;