数据sql
------------CCW_PUSH_RECORD_TEMP造50数据sql--------CCWP------------------------------------DECLARE V_WAYBILLNO VARCHAR2(12) := 786786504487;BEGIN FOR V_I IN 1 .. 20 LOOP V_WAYB
·
--------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;
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;
更多推荐
已为社区贡献2条内容
所有评论(0)