CREATE TABLE adjdli (yearmonth VARCHAR2(8), cb number, empcode VARCHAR2(8), mmth VARCHAR2(3), debits NUMBER) INSERT INTO adjdli (YEARMONTH,CB,EMPCODE,MMTH,DEBITS) VALUES ('20032004',46610,'02506348','Apr',0) INSERT INTO adjdli (YEARMONTH,CB,EMPCODE,MMTH,DEBITS) VALUES ('20032004',48099,'02506348','May',0) INSERT INTO adjdli (YEARMONTH,CB,EMPCODE,MMTH,DEBITS) VALUES ('20032004',49588,'02506348','Jun',0) INSERT INTO adjdli (YEARMONTH,CB,EMPCODE,MMTH,DEBITS) VALUES ('20032004',51477,'02506348','Jul',0) INSERT INTO adjdli (YEARMONTH,CB,EMPCODE,MMTH,DEBITS) VALUES ('20032004',53366,'02506348','Aug',0) INSERT INTO adjdli (YEARMONTH,CB,EMPCODE,MMTH,DEBITS) VALUES ('20032004',55255,'02506348','Sep',0) INSERT INTO adjdli (YEARMONTH,CB,EMPCODE,MMTH,DEBITS) VALUES ('20032004',57144,'02506348','Oct',0) INSERT INTO adjdli (YEARMONTH,CB,EMPCODE,MMTH,DEBITS) VALUES ('20032004',59233,'02506348','Nov',0) INSERT INTO adjdli (YEARMONTH,CB,EMPCODE,MMTH,DEBITS) VALUES ('20032004',61322,'02506348','Dec',0) INSERT INTO adjdli (YEARMONTH,CB,EMPCODE,MMTH,DEBITS) VALUES ('20032004',66611,'02506348','Jan',0) INSERT INTO adjdli (YEARMONTH,CB,EMPCODE,MMTH,DEBITS) VALUES ('20032004',72950,'02506348','Feb',0) INSERT INTO adjdli (YEARMONTH,CB,EMPCODE,MMTH,DEBITS) VALUES ('20032004',79289,'02506348','Mar',0) INSERT INTO adjdli (YEARMONTH,CB,EMPCODE,MMTH,DEBITS) VALUES ('20042005',87651,'02506348','Apr',0) INSERT INTO adjdli (YEARMONTH,CB,EMPCODE,MMTH,DEBITS) VALUES ('20042005',91590,'02506348','May',0) INSERT INTO adjdli (YEARMONTH,CB,EMPCODE,MMTH,DEBITS) VALUES ('20042005',95529,'02506348','Jun',0) INSERT INTO adjdli (YEARMONTH,CB,EMPCODE,MMTH,DEBITS) VALUES ('20042005',99468,'02506348','Jul',0) INSERT INTO adjdli (YEARMONTH,CB,EMPCODE,MMTH,DEBITS) VALUES ('20042005',103407,'02506348', 'Aug',0) INSERT INTO adjdli (YEARMONTH,CB,EMPCODE,MMTH,DEBITS) VALUES ('20042005',107346,'02506348','Sep',0) INSERT INTO adjdli (YEARMONTH,CB,EMPCODE,MMTH,DEBITS) VALUES ('20042005',116121,'02506348','Oct',0) INSERT INTO adjdli (YEARMONTH,CB,EMPCODE,MMTH,DEBITS) VALUES ('20042005',120060,'02506348','Nov',0) INSERT INTO adjdli (YEARMONTH,CB,EMPCODE,MMTH,DEBITS) VALUES ('20042005',124046,'02506348','Dec',0) commit