造数据-add_data

declare 
v_date02 varchar(20);
i number;
begin 
  i:=0;
  v_date02:='2016-11-01';  --修改起始日期 修改此参数
  while i <5000000  loop  --循环多少次   1500 万 修改此参数  
  insert into /*+append*/ js_skskjdk_dzfpmx (SBBH, FPDM, FPHM, TSPZ, FPZTBZ, MW, JYM, XFSH, XFMC, XFDZDH, XFYHZH, GFSH, GFMC, GFDZDH, GFYHZH, KPRQ, KPSJ, ZFRQ, ZFSJ, JE, SE, JSHJ, BZ, KPR, SKR, FHR, HZFPXXBBH, YFPDM, YFPHM, FPQM, YQBZ, KJLX, BSFS, DCBZ, DCRQ, JSR, JSSJ, SWJG_DM, JSSWJG_DM, BMB_BBH, SLBZ)
values ('9999000012222', '99900512222', 00000001+i, null, '0', '03+1302>*565327--*4/9*79>/0*2>85>9487*162678317-5>9+-<5/24+3-+6/2+19-<05065>55>9<27**38<+91890015*9719>1559+<>29', '00361036952505463570', '11010119890103X', '测试', '11', '11', '11111111111111111111', '普通征收', null, null,to_date(v_date02, 'yyyy-mm-dd'), '083547', null, null, 100.00, 17.00, 117.00, null, '管理员', '管理员', '管理员', null, null, null, 'MIIBNgYJKoZIhvcNAQcCoIIBJzCCASMCAQExCzAJBgUrDgMCGgUAMAsGCSqGSIb3DQEHATGCAQIwgf8CAQEwXTBTMQswCQYDVQQGEwJDTjEbMBkGA1UECwwS5Zu95a6256iO5Yqh5oC75bGAMScwJQYDVQQDDB7nqI7liqHnlLXlrZDor4HkuabnrqHnkIbkuK3lv4MCBgEAAABxfzAJBgUrDgMCGgUAMA0GCSqGSIb3DQEBAQUABIGAVhycRTuKZObkrBz95fBkNW7eFArcs3/mfPmQo/M/3E251ocYYpd2n0oqtGBuuWJnZLURcXAvTGhSsrP4V8wRUUEktiDEhniwYVzQPoxuGlY4DfUsND1cExuwtV4vMLKEgP+kfSlL3NTsLSAC2kVoOKLhsFGosWxUw94TU9kVd3c=', '0', '1', '9', null, null, '99999999999', to_date(v_date02, 'yyyy-mm-dd'), '111010100', '111010100', '34.4', '0');
--修改fpdm 修改此参数

for j in 1..trunc(dbms_random.value(1,3))   loop
insert into /*+append*/ js_skskjdk_dzfpmx_zb (FPDM, FPHM, MXXH, MC, GGXH, JLDW, SHUL, DJ, JE, SL, SE, JSSJ, KPRQ, SPBM, ZXBM, YHZCBS, ZZSTSGL, LSLBS)
values ('999005112222', 00000001+i,j,'其他低速载货汽车', null, null, null, null, 95.71, 0.050, 4.29, to_date(v_date02, 'yyyy-mm-dd'),to_date(v_date02, 'yyyy-mm-dd'), '1090307020000000000', null, '0', null, null);
--修改fphm 修改此参数
end loop;

    if mod(i,5)=0 then  --每天的数据量  50 万 修改此参数         
    v_date02:= to_char(to_date(v_date02,'yyyy-mm-dd')+1/1024,'yyyy-mm-dd');   
    commit; 
    end if;
    
    i:=i+1;
    end loop;
    commit;
      
end;
/