oracle

数据库表里数据多时，执行删除时可以用:TRUNCATE TABLE name;

注意与delete的区别；

---

 

循环插数据：

declare
i int;
begin
for i in 1..4163040 loop
Insert into OMS_DATA_DEV_UW

(ID,DEVICE_ID,POSITION,MONITOR_ID,SENSOR_ID,YELLOW_THRESHOLD,RED_THRESHOLD,THRESHOLD_FLAG
,MONITOR_TIME,SOUND_LENGTH,POWER_ZQ_LEN,POWER_ZQ,AVG_DB)
Values
(IBATIS_SEQUENCE.nextval,1,'Behind',1,2,1,2,9, TO_DATE('2008/01/01 0:0', 'YYYY/MM/DD
HH24:MI')+i/(24*60),9,1,2,dbms_random.value(20,70));
if mod(i,1000)=0 then
commit;
end if;
end loop;
end;