CMIS PROJECT

Drop Table FINANCING_PLANS; CREATE TABLE FINANCING_PLANS (FPID VARCHAR2(12), INSTITUTION VARCHAR2(12), PERCENTAGE VARCHAR2(12), LOAN_TYPE VARCHAR2(12), MAX_TERM INTEGER, MIN_DOWN FLOAT, MAX_LOAN_AMT FLOAT, CONSTRAINT FINANCING_PLANS_PK PRIMARY KEY (FPID) ); Insert into FINANCING_PLANS (FPID, INSTITUTION, PERCENTAGE, LOAN_TYPE, MAX_TERM, MIN_DOWN, MAX_LOAN_AMT) Values ('FP0001', 'BANK', '8', 'CONSUMER', 4, 3500, 50000); Insert into FINANCING_PLANS (FPID, INSTITUTION, PERCENTAGE, LOAN_TYPE, MAX_TERM, MIN_DOWN, MAX_LOAN_AMT) Values ('FP0002', 'BANK', '5', 'CONSUMER', 5, 1000, 20000); Insert into FINANCING_PLANS (FPID, INSTITUTION, PERCENTAGE, LOAN_TYPE, MAX_TERM, MIN_DOWN, MAX_LOAN_AMT) Values ('FP0003', 'BANK', '9', 'CONSUMER', 6, 3300, 45000); Insert into FINANCING_PLANS (FPID, INSTITUTION, PERCENTAGE, LOAN_TYPE, MAX_TERM, MIN_DOWN, MAX_LOAN_AMT) Values ('FP0004', 'BANK', '9', 'CONSUMER', 7, 3300, 45000); Insert into FINANCING_PLANS (FPID, INSTITUTION, PERCENTAGE, LOAN_TYPE, MAX_TERM, MIN_DOWN, MAX_LOAN_AMT) Values ('FP0005', 'BANK', '9', 'CONSUMER', 7, 6500, 65000);