批量生成大数据的sql



方法一：
declare
cnt number(9);
begin
  cnt:=0;
  while cnt < 100
  loop
 
insert into ts_customs_fee_fin (ID, FEEDATE, PORT, IEFLAG, BIG_CUSTOM_DEPT, FEE_CODE, FEE_LEVEL, FEE_OCCUR_DATE, CREATEUSER, CREATEDATE, GENERATION_TYPE, LASTUPDATE, LASTUPUSER, CUSTOMS_CLEARANCE_TYPE, TRANSPORT_MODE, CUSTOMS_DATE, CUSBATCH, MAWB, FLIGHTNO, BNO, GATE_TYPE, CARGO_TYPE, LIMIT_TYPE_CODE, PRODUCT_CODE, FEE_SORT, CALCULATE_OBJECT2, ACCOUNT_RULES_ID, ACCOUNT_QUANTITY, FEE, DATA_SOURCE, REMARK, STATE, SUPPLIER_NAME, SRC_ADDR, DES_ADDR, OCCURRATE, CUSTYPE, TAXPAYMENTTYPE, RECON_ID, SERVICE_NAME, BIZ_ID, DEL_MARK, SUPPLIER_CODE, CALCULATE_OBJECT1, EXCEPT_ID, FEE_NAME, GJAHR_MONAT_STR, PROJT, CUSTM, GJAHR_MONAT)
values (SEQ_TS_CUSTOMS_FEE.Nextval, '201609', 'RIO', 'I', '海外', 911, '1', to_date('25-09-2016',