oracle undefine的用法_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;