731
技術社區[雲棲]
sql 腳本
insert into SA_ACCTINFQRYRSPN (ROW_ID, MSGTYPE, ORIMSGID, ORISENDBANK, MSGID, QUERYTYPE, RSPFLAG, SENDSAPBANK, SENDBANK, WORKDATE, PTYCTGY, MMBID, ISSR, ACCTSTS, PLDGFINCGID, OVERDRFTLMT, BAL, CDTLD, RSTRCTAMTLWRLMT, LNDGBALAMTLWRLMT, FNDBALAMTLWRLMT) values (6, 'saps.367.001.01', '2012123000000032', '501290000012', '2012123001332208', '3', '1', '0000', '0000', '20120516', 'PC00', '501290000012', 'ACTNAME', 'AS01', 'PF02', 0, 29668022494.95, 29448816900, 0, 0, 0); insert into SA_ACCTINFQRYRSPN (ROW_ID, MSGTYPE, ORIMSGID, ORISENDBANK, MSGID, QUERYTYPE, RSPFLAG, SENDSAPBANK, SENDBANK, WORKDATE, PTYCTGY, MMBID, ISSR, ACCTSTS, PLDGFINCGID, OVERDRFTLMT, BAL, CDTLD, RSTRCTAMTLWRLMT, LNDGBALAMTLWRLMT, FNDBALAMTLWRLMT) values (3, 'saps.367.001.01', '2012123000000030', '501290000012', '2012123001332017', '3', '1', '0000', '0000', '20120516', 'PC00', '501290000012', 'ACTNAME', 'AS01', 'PF02', 0, 29668022494.95, 29448816900, 0, 0, 0); insert into SA_ACCTINFQRYRSPN (ROW_ID, MSGTYPE, ORIMSGID, ORISENDBANK, MSGID, QUERYTYPE, RSPFLAG, SENDSAPBANK, SENDBANK, WORKDATE, PTYCTGY, MMBID, ISSR, ACCTSTS, PLDGFINCGID, OVERDRFTLMT, BAL, CDTLD, RSTRCTAMTLWRLMT, LNDGBALAMTLWRLMT, FNDBALAMTLWRLMT) values (4, 'saps.367.001.01', '2012123000000029', '501290000012', '2012123001332201', '3', '1', '0000', '0000', '20120516', 'PC00', '501290000012', 'ACTNAME', 'AS01', 'PF02', 0, 29668022494.95, 29448816900, 0, 0, 0); insert into SA_ACCTINFQRYRSPN (ROW_ID, MSGTYPE, ORIMSGID, ORISENDBANK, MSGID, QUERYTYPE, RSPFLAG, SENDSAPBANK, SENDBANK, WORKDATE, PTYCTGY, MMBID, ISSR, ACCTSTS, PLDGFINCGID, OVERDRFTLMT, BAL, CDTLD, RSTRCTAMTLWRLMT, LNDGBALAMTLWRLMT, FNDBALAMTLWRLMT) values (5, 'saps.367.001.01', '2012123000000031', '501290000012', '2012123001332202', '3', '1', '0000', '0000', '20120516', 'PC00', '501290000012', 'ACTNAME', 'AS01', 'PF02', 0, 29668022494.95, 29448816900, 0, 0, 0); insert into SA_ACCTINFQRYRSPN (ROW_ID, MSGTYPE, ORIMSGID, ORISENDBANK, MSGID, QUERYTYPE, RSPFLAG, SENDSAPBANK, SENDBANK, WORKDATE, PTYCTGY, MMBID, ISSR, ACCTSTS, PLDGFINCGID, OVERDRFTLMT, BAL, CDTLD, RSTRCTAMTLWRLMT, LNDGBALAMTLWRLMT, FNDBALAMTLWRLMT) values (21, 'saps.367.001.01', '2012123000000044', '501290000012', '2012123001344005', '3', '1', '0000', '0000', '20120516', 'PC00', '501290000012', 'ACTNAME', 'AS01', 'PF02', 0, 29664552064.95, 29448816900, 0, 0, 0); commit;
最後更新：2017-04-02 17:28:36