User:JQF/code

The printable version is no longer supported and may have rendering errors. Please update your browser bookmarks and please use the default browser print function instead.

-- Christopher Foster, 35SC1, insasn.sql -- data is alway Case Sensitive!!!!!!!

insert into si2.CUSTOMER values ('CHRISTOPHER FOSTER', '41 SPEERS RD', 'OAKVILLE', 'ONTARIO', , , ); insert into si2.CUSTOMER values ('LOUIS CYR', '1 ST RENGTH ST', 'MONTREAL', 'QUEBEC', , , );

insert into si2.CAR values ('98603369', 'CHRISTOPHER FOSTER', 'JAGUAR', 'XK', '2007', 'SILVER', 'BLACK', '4.2L AJ34', , '14-JAN-2007', , 100000, 10000, 200000, 200000); insert into si2.CAR values ('18859843', 'LOUIS CYR', 'LAND ROVER', 'DEFENDER', '1975', 'FOREST GREEN', 'BLACK', '2.25L V8', , '14-JUN-2000', , 1000000, 10000, 2000000, 2000000);

insert into si2.SALEINV values ('209342', 'CHRISTOPHER FOSTER', 'LEMME SCAMMU', '14-JAN-2007', '98603269', 200000, 0, 0, 0, 0, 0, , 0, 'Y', 'Y', 'Y', 'Y'); insert into si2.SALEINV values ('209343', 'LOUIS CYR', 'LEMME SCAMMU', '14-JUN-2000', '18859842', 2000000, 0, 0, 0, 0, 0, , 0, 'Y', 'Y', 'N', 'Y');

insert into si2.BASEOPTION values ('98603369', 'CD2'); insert into si2.BASEOPTION values ('98603369', 'ED3'); insert into si2.BASEOPTION values ('98603369', 'R41'); insert into si2.BASEOPTION values ('98603369', 'S20'); insert into si2.BASEOPTION values ('98603369', 'M14'); insert into si2.BASEOPTION values ('98603369', 'R96'); insert into si2.BASEOPTION values ('18859843', 'M24'); insert into si2.BASEOPTION values ('18859843', 'E01'); insert into si2.BASEOPTION values ('18859843', 'R00');

insert into si2.SERVINV values ('93406', '21-JAN-2007', 'LOUIS CYR', '18859843', 100, 100, 30, 230);

insert into si2.SERVWORK values ('93406', 'Oil change');

insert into si2.PROSPECT values ('CHRISTOPHER FOSTER', 'JAGUAR', 'XR', '2008', 'SILVER', 'BLACK', 'ED3'); insert into si2.PROSPECT values ('CHRISTOPHER FOSTER', 'JAGUAR', 'XR', '2008', 'BURNT ORANGE', 'BLACK', 'ED3'); insert into si2.PROSPECT values ('LOUIS CYR', 'LAND ROVER', , '1990', , 'BLACK', 'R00'); insert into si2.PROSPECT values ('LOUIS CYR', 'ACURA', , '1990', , 'BLACK', 'R00');

insert into si2.EMPLOYEE values ('Lemme Scammu', '01-JAN-2000','Howe Scammu', 00,'Employee');