DBST 651 (Formerly CSMN 661) Sample Scripts:

Load Data

SPOOL LOAD

DELETE FROM NOTE;
DELETE FORM CHECKING;
DELETE FROM SAVING;
DELETE FROM CUSTOMR;
DELETE FROM ZIP;

INSERT INTO ZIP VALUES ('12345', 'NEW YORK','NY');
INSERT INTO ZIP VALUES ('22222', 'WASHINGTON','DC');
INSERT INTO ZIP VALUES ('33333', 'GAITHERSBURG','MD');
INSERT INTO ZIP VALUES ('44444', 'OLNEY','MD');
INSERT INTO ZIP VALUES ('55555', 'SAN DIEGO','CA');

INSERT INTO CUSTOMER VALUES (1234567890, 123456789, 'SALLY','M', 'SMITH', '12 MAIN ST', 100, 500, '33333');
INSERT INTO CUSTOMER VALUES (2222222222, 987654321, 'SAM','L', 'JONES', '60 FIELD RD', 1000, 2000,'33333');
INSERT INTO CUSTOMER VALUES (5555555555, 555557777, 'JILL','K', 'MILLER', '75 AMBER WAY', 5000, 5000,'44444');
INSERT INTO CUSTOMER VALUES (6666666666, 888844444, 'MIKE','P', 'McMOHAN', '1001 4TH ST', 200, 300,'12345');
INSERT INTO CUSTOMER VALUES (8888888888, 123459999, 'BOB','F', 'JOHNSON', '12343 MEADOW LANE', 500, 1000,'55555');

INSERT INTO CHECKING VALUES (1234567811, 1234567890, 12300001, 200);
INSERT INTO CHECKING VALUES (1234567811, 1234567890, 12300002, -100);
INSERT INTO CHECKING VALUES (5555555522, 5555555555, 01010101, 200);
INSERT INTO CHECKING VALUES (8888888811, 8888888888, 01010101, 500);
INSERT INTO CHECKING VALUES (6666666611, 6666666666, 01020102, 100);

INSERT INTO SAVING VALUES (1234567855, 1234567890, 12300001, 500);
INSERT INTO SAVING VALUES (1234567855, 1234567890, 12300002, 300);
INSERT INTO SAVING VALUES (2222222255, 2222222222, 12300001, -500);
INSERT INTO SAVING VALUES (5555555566, 5555555555, 12300001, 100);
INSERT INTO SAVING VALUES (5555555566, 5555555555, 01010101, 100);

INSERT INTO NOTE VALUES (123456781, '30-DEC-00', 1234567890, 'Customer cashed savings bond for 500 dollars then received 100 dollars cash');
INSERT INTO NOTE VALUES (555555551, '01-JAN-01', 5555555555, 'Customer inquired about car loan');
INSERT INTO NOTE VALUES (888888881, '01-JAN-01', 8888888888, 'Customer indicated he will buy a new house soon');
INSERT INTO NOTE VALUES (555555551, '30-DEC-00', 5555555555, 'Customer entered safe deposit area');
INSERT INTO NOTE VALUES (666666661, '02-JAN-01', 6666666666, 'Customer was warned about overdraft and advised to get protection');

SPOOL OFF

Home