Insert into TRANSACTION
   (TNO, TRANSMID, TRANSTIME, METHOD, BANKID, BANKNAME, CARDTYPE, CARDID, DUEDATE)
 Values
   ('92222', 'a0911234', '2003/1/1 11:30:00', 'cart', '010', 'tb', 'visa', '987654321', '2005-01-01');
Insert into TRANSACTION
   (TNO, TRANSMID, TRANSTIME, METHOD, BANKID, BANKNAME, CARDTYPE, CARDID, DUEDATE)
 Values
   ('92555', 'b0922468', '2003/11/11 09:10:00', 'cart', '010', 'tb', 'visa', '333300000', '2004-01-01');
Insert into TRANSACTION
   (TNO, TRANSMID, TRANSTIME, METHOD, BANKID, BANKNAME, CARDTYPE, CARDID, DUEDATE)
 Values
   ('90111', 'b0905555', '2002/5/5 12:30:30', 'cart', '020', 'fb', 'master', '444455555', '2003-01-01');
Insert into TRANSACTION
   (TNO, TRANSMID, TRANSTIME, METHOD, BANKID, BANKNAME, CARDTYPE, CARDID, DUEDATE)
 Values
   ('92333', 'c0927777', '2003/10/15 09:00:00', 'email', '070', 'sb', 'visa', '111122222', '2004-12-31');
Insert into TRANSACTION
   (TNO, TRANSMID, TRANSTIME, METHOD, BANKID, BANKNAME, CARDTYPE, CARDID, DUEDATE)
 Values
   ('91888', 'a0910001', '2002/9/10 10:10:00', 'fax', '040', 'cb', 'master', '777788888', '2004-10-10');
Insert into TRANSACTION
   (TNO, TRANSMID, TRANSTIME, METHOD, BANKID, BANKNAME, CARDTYPE, CARDID, DUEDATE)
 Values
   ('92666', 'c0927777', '2003/10/10 22:10:30', 'cart', '020', 'fb', 'visa', '123456789', '2003-12-31');
Insert into TRANSACTION
   (TNO, TRANSMID, TRANSTIME, METHOD, BANKID, BANKNAME, CARDTYPE, CARDID, DUEDATE)
 Values
   ('91100', 'a0911234', '2004/7/27 18:30:00', 'cart', '010', 'tb', 'visa', '987654321', '2005-01-01');
COMMIT;
