
DELETE FROM ITSO.TRANSACT;
DELETE FROM ITSO.ACCOUNT;


INSERT INTO ITSO.ACCOUNT (BALANCE,ID) VALUES (12345.67, '001-111001');
INSERT INTO ITSO.ACCOUNT (BALANCE,ID) VALUES (6543.21,  '001-111002');
INSERT INTO ITSO.ACCOUNT (BALANCE,ID) VALUES (98.76,    '001-111003');

INSERT INTO ITSO.ACCOUNT (BALANCE,ID) VALUES (65484.23, '002-222001');
INSERT INTO ITSO.ACCOUNT (BALANCE,ID) VALUES (87.96,    '002-222002');
INSERT INTO ITSO.ACCOUNT (BALANCE,ID) VALUES (654.65,   '002-222003');

INSERT INTO ITSO.ACCOUNT (BALANCE,ID) VALUES (9876.52,  '003-333001');
INSERT INTO ITSO.ACCOUNT (BALANCE,ID) VALUES (568.79,   '003-333002');
INSERT INTO ITSO.ACCOUNT (BALANCE,ID) VALUES (21.56,    '003-333003');

INSERT INTO ITSO.ACCOUNT (BALANCE,ID) VALUES(987.65,    '004-444001');
INSERT INTO ITSO.ACCOUNT (BALANCE,ID) VALUES(1456.45,   '004-444002');
INSERT INTO ITSO.ACCOUNT (BALANCE,ID) VALUES(23156.46,  '004-444003');

INSERT INTO ITSO.ACCOUNT (BALANCE,ID) VALUES(65.89,     '005-555001');
INSERT INTO ITSO.ACCOUNT (BALANCE,ID) VALUES(72213.41,  '005-555002');
INSERT INTO ITSO.ACCOUNT (BALANCE,ID) VALUES(897.55,    '005-555003');

INSERT INTO ITSO.ACCOUNT (BALANCE,ID) VALUES(500.00,    '006-666001');
INSERT INTO ITSO.ACCOUNT (BALANCE,ID) VALUES(100.00,    '006-666002');
INSERT INTO ITSO.ACCOUNT (BALANCE,ID) VALUES(10000.00,  '006-666003');

INSERT INTO ITSO.ACCOUNT (BALANCE,ID) VALUES(500.00,    '007-777001');

INSERT INTO ITSO.ACCOUNT (BALANCE,ID) VALUES(500.00,    '008-888001');

INSERT INTO ITSO.ACCOUNT (BALANCE,ID) VALUES(500.00,    '009-999001');

INSERT INTO ITSO.ACCOUNT (BALANCE,ID) VALUES (66666.66, '000-000001');
INSERT INTO ITSO.ACCOUNT (BALANCE,ID) VALUES (6666.66,  '000-000002');
INSERT INTO ITSO.ACCOUNT (BALANCE,ID) VALUES (66.66,    '000-000003');


INSERT INTO ITSO.TRANSACT(ID,TRANS_TYPE,TRANS_TIME,AMOUNT,ACCOUNT_ID) Values('0000001', 'Credit', '1990-01-01 23:23:23', 2222.22, '002-222001'); 
INSERT INTO ITSO.TRANSACT(ID,TRANS_TYPE,TRANS_TIME,AMOUNT,ACCOUNT_ID) Values('0000002', 'Debit',  '1994-02-02 10:11:12',  800.80, '002-222001'); 
INSERT INTO ITSO.TRANSACT(ID,TRANS_TYPE,TRANS_TIME,AMOUNT,ACCOUNT_ID) Values('0000003', 'Credit', '1997-03-03 15:16:17',   21.50, '002-222001');
INSERT INTO ITSO.TRANSACT(ID,TRANS_TYPE,TRANS_TIME,AMOUNT,ACCOUNT_ID) Values('0000004', 'Debit',  '1998-04-04 22:22:22', 1000.11, '002-222001'); 
INSERT INTO ITSO.TRANSACT(ID,TRANS_TYPE,TRANS_TIME,AMOUNT,ACCOUNT_ID) Values('0000005', 'Debit',  '2001-05-05 13:44:20',  876.54, '002-222001'); 
INSERT INTO ITSO.TRANSACT(ID,TRANS_TYPE,TRANS_TIME,AMOUNT,ACCOUNT_ID) Values('0000006', 'Debit',  '2002-06-06 12:12:12',    3.33, '002-222002'); 
INSERT INTO ITSO.TRANSACT(ID,TRANS_TYPE,TRANS_TIME,AMOUNT,ACCOUNT_ID) Values('0000008', 'Credit', '2003-07-07 14:14:14', 6666.66, '002-222002'); 
INSERT INTO ITSO.TRANSACT(ID,TRANS_TYPE,TRANS_TIME,AMOUNT,ACCOUNT_ID) Values('0000009', 'Credit', '2004-01-08 23:03:20',  700.77, '002-222002'); 
INSERT INTO ITSO.TRANSACT(ID,TRANS_TYPE,TRANS_TIME,AMOUNT,ACCOUNT_ID) Values('0000010', 'Credit', '1943-01-07 10:30:20', 9999.99, '000-000001'); 
