Oracle随机生成数目字存储过程

Oracle随机生成数字存储过程

create or replace procedure create_callstatisticasbeginfor i in 1..4000000loopinsert into up_callstatistic_data(USERIDENTIFIER,UPNUMBER,CALLINGADDRESS,CALLINGAREANUMBER,CALLEDADDRESS,CALLEDAREANUMBER,CALLSTARTTIME) values(round(dbms_random.value(1000000000,2000000000)),round(dbms_random.value(4008000000,4008999999)),round(dbms_random.value(51180000000,51189999999)),round(dbms_random.value(350,999)),round(dbms_random.value(51180000000,51189999999)),round(dbms_random.value(350,999)),'2011031311'||round(dbms_random.value(00,59))||round(dbms_random.value(00,59)));commit;end loop；

end;