PLSQL 执行存储过程 17位随机时间，随机码生成

 

PLSQL 执行存储过程

 

 

begin for i in 1..10000000 loop casekey := 'TMP'||lpad(i,7,0); -- TMP0000001 insert into TMP_UPSTATE_CASEKEY values(casekey, 1, sysdate); end loop; commit; end;

随机码生成：

 select '35112017'||LPAD(rownum,18,0),1,sysdate from dual

17位随机时间：

 

select '20170109'||LPAD(round(mod(dbms_random.value*100,23)), 2, 0)||LPAD(round(mod(dbms_random.value*100,59)), 2, 0)||LPAD(round(mod(dbms_random.value*100,59)), 2, 0)||LPAD(round(mod(dbms_random.value*100,999)), 3, 0) from dual

 

 

SELECT to_date(TRUNC(DBMS_RANDOM.VALUE(
to_number(to_char(to_date('20150101','yyyymmdd'),'J')),
to_number(to_char(to_date('20150501','yyyymmdd')+1,'J')))),'J')+
DBMS_RANDOM.VALUE(1,3600)/3600
prize_time
FROM dual;
select round(mod(dbms_random.value*100,24)) from dual;

select * from round(mod(dbms_random.value*100,24))

 

 

 

 

 

 

 

 

 

 

 

 

看代码：

 

create or replace procedure proc_create_zffundinmaindata as
begin
   for i in 1..20 loop
        INSERT INTO ZF_FUNDINORDERMAIN
          (ACCOUNTTIME,
           ACTIONTYPE,
           BUSINESSTYPE,
           CONTEXTID,
           INSTITUTIONID,
           RESPONSECODE,
           RESPONSEMESSAGE,
           RESPONSETIME,
           ROOTID,
           SETTLEMENTFLAG,
           SOURCETXSN,
           SOURCETXTIME,
           STATUS,
           SYSTEMNO,
           SYSTEMTIME,
           TXTYPE)
        VALUES
          ('20170109171414300',
           '12',
           '12',
           '30112017'||LPAD(i,18,0),
           '000020',
           '2000',
           'OK.',
           '20170109171449306',
           '22212017'||LPAD(i,18,0),
           '',
           '201701091712477803534321864',
           '20170109171406654',
           '20',
           '35112017'||LPAD(i,18,0),
           '20170109171418156',
           '1361');
          end loop;
          commit;
end proc_create_zffundinmaindata;

  --exec proc_create_zffundinmaindata;--执行
  
    

 

右键：

 

选择Test 就可以运行了