sql 脚本

来源：互联网发布：linux下的dd命令编辑：程序博客网时间：2024/05/21 06:21
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;