数据sql

--------1----CCW_PUSH_RECORD_TEMP造50数据sql--------CCWP------------------------------------




DECLARE
  
  V_WAYBILLNO VARCHAR2(12) := 786786504487;
BEGIN
  FOR V_I IN 1 .. 20 LOOP
    V_WAYBILLNO := V_WAYBILLNO + 1;
    insert into ccw_push_record_temp (ID, BNO, PHONE, B_TYPE, CREATE_TIME, UPDATE_TIME)
values (SEQ_CCW_PUSH_RECORD_TEMP.NEXTVAL, V_WAYBILLNO , '18718868393', '50', to_date('6-1-2016 15:15:50', 'dd-mm-yyyy hh24:mi:ss'), null);
    
    COMMIT;
  END LOOP;
END;

----------------2---------------------CCW_BAR_SYNC_RECORD造50数据sql-CCWP---


DECLARE
  V_BNO number := 855123456789;-------数字格式
BEGIN
  FOR V_I IN 1 .. 20 LOOP
    V_BNO := V_BNO + 1;
    insert into CCW_BAR_SYNC_RECORD
      (BNO, PHONE, CREATE_TM, ID, UPDATE_TM, PHONE_ZONE, ZONE_CODE)
    values
      (V_BNO,
       '13421841858',
       sysdate,-----当前时间
       SEQ_CCWP_BAR_SYNC_RECORD.NEXTVAL,-----下一个正常的格式
     sysdate,-----当前时间
       '755',
       '755');
      COMMIT;
  END LOOP;
END;


--------3----CCW_PUSH_RECORD_TEMP造50数据sql--------------------------------------------


DECLARE
  V_I         NUMBER;
  V_WAYBILLNO VARCHAR2(12) := 896040399588;
BEGIN
  FOR V_I IN 1 .. 20 LOOP
    V_WAYBILLNO := V_WAYBILLNO + V_I;
    insert into exp5.tt_bar_record
      (BAR_RECORD_ID,
       WAYBILL_NO,
       ZONE_CODE,
       OP_CODE,
       OP_ATTACH_INFO,
       COURIER_CODE,
       BAR_OPR_CODE,
       BAR_UPLOAD_TM,
       OBJ_TYPE_CODE,
       CONTNR_CODE,
       PAY_FLG,
       STAY_WHY_CODE,
       SUBBILL_PIECE_QTY,
       BAR_UPLOAD_TYPE_CODE,
       WEIGHT_QTY,
       FEE_AMT,
       ACCOUNTANT_CODE,
       OTHER_INFO,
       OP_NAME,
       ZONE_TYPE_CODE,
       ENCRYPT_STRING,
       BAR_SN,
       SCHEDULE_CODE,
       SIGN_TYPE_CODE,
       SRC_CONTNR_CODE,
       PHONE_ZONE,
       PHONE,
       STOP_OVER_FLG,
       BATCH_CODE,
       DEST_ZONE_CODE,
       AUTOLOADING,
       BAR_SCAN_TM,
       BAR_SCAN_DT,
       EXTEND_ATTACH_1,
       EXTEND_ATTACH_2,
       BAR_UPLOAD_OPR_CODE,
       EXTEND_ATTACH_3,
       EXTEND_ATTACH_4,
       EXTEND_ATTACH_5,
       EXTEND_ATTACH_6,
       EXTEND_ATTACH_7,
       BAR_UPLOAD_TM_STD,
       BAR_SCAN_TM_STD,
       SF_CVS_CODE,
       PROD_TYPE)
    values
      (seq_tt_bar_record.nextval,
       V_WAYBILLNO,
       '755A',
       '50', -----OP
       '',
       '046154',
       '046154',
       to_date('07-01-2016 17:28:27', 'dd-mm-yyyy hh24:mi:ss'),
       20,
       '',
       null,
       '',
       1,
       1,
       null,
       null,
       '',
       '',
       '一票一件',
       null,
       '',
       '',
       '',
       null,
       '',
       '755',
       '13421841858',
       null,
       '',
       '',
       '3',
       to_date('07-01-2016 15:59:09', 'dd-mm-yyyy hh24:mi:ss'),
       null,
       'HHT',
       '',
       '',
       '33',
       '',
       '',
       '',
       '',
       to_date('07-01-2016 17:28:27', 'dd-mm-yyyy hh24:mi:ss'),
       to_date('07-01-2016 15:59:09', 'dd-mm-yyyy hh24:mi:ss'),
       '',
       '');
  
    DBMS_OUTPUT.PUT_LINE(V_WAYBILLNO);
    INSERT INTO tt_bar_record_log
      (record_id)
      SELECT bar_record_id
        FROM tt_bar_record
       WHERE waybill_no = V_WAYBILLNO;
    dbms_output.put_line(V_WAYBILLNO);
    COMMIT;
  END LOOP;
END;




------------4------------------FVP弥朝彭的例子-------
DECLARE
  V_I         NUMBER;
  V_WAYBILLNO VARCHAR2(12) := 496040399588;
BEGIN
  FOR V_I IN 1 .. 10 LOOP
    V_WAYBILLNO := V_WAYBILLNO + 1;
    insert into tt_bar_record (BAR_RECORD_ID, WAYBILL_NO, ZONE_CODE, OP_CODE, OP_ATTACH_INFO, COURIER_CODE, BAR_OPR_CODE, BAR_UPLOAD_TM, OBJ_TYPE_CODE, CONTNR_CODE, PAY_FLG, STAY_WHY_CODE, SUBBILL_PIECE_QTY, BAR_UPLOAD_TYPE_CODE, WEIGHT_QTY, FEE_AMT, ACCOUNTANT_CODE, OTHER_INFO, OP_NAME, ZONE_TYPE_CODE, ENCRYPT_STRING, BAR_SN, SCHEDULE_CODE, SIGN_TYPE_CODE, SRC_CONTNR_CODE, PHONE_ZONE, PHONE, STOP_OVER_FLG, BATCH_CODE, DEST_ZONE_CODE, AUTOLOADING, BAR_SCAN_TM, BAR_SCAN_DT, EXTEND_ATTACH_1, EXTEND_ATTACH_2, BAR_UPLOAD_OPR_CODE, EXTEND_ATTACH_3, EXTEND_ATTACH_4, EXTEND_ATTACH_5, EXTEND_ATTACH_6, EXTEND_ATTACH_7, BAR_UPLOAD_TM_STD, BAR_SCAN_TM_STD)
    values (V_WAYBILLNO,V_WAYBILLNO, '755A', '630', '', '171403', '1000005565', sysdate, 20, '', 0, '', 0, 0, '1.000', 0.0000, '', 'T4', '落地配派件出仓  ', 0, '424', 'V6.6.2', '', 0, '', '', '', 0, '', '', '1', sysdate, sysdate, '', '', '171403', '', '', '', '', sysdate, sysdate, sysdate);
    DBMS_OUTPUT.PUT_LINE(V_WAYBILLNO);
   INSERT INTO tt_bar_record_log(record_id) SELECT bar_record_id FROM tt_bar_record WHERE waybill_no=
       V_WAYBILLNO;
       dbms_output.put_line(V_WAYBILLNO);
       COMMIT;
  END LOOP;
END;