Data Inserted into the Database

Return to Home Page

I am going to make the data available to you to in a number of different fashions:

1. As a Zipped file called inmeddat2.zip for faster Downloading (Click Here)

2. As a regular ASCII file on the Computer Lab Server (Called inmeddata.sql)

3. As a listing (see below: DON'T TRY AND COPY AND PASTE)

To insert the Data, all you need to do is run the script:

SQL> @inmeddata.sql;

IF you see ANY error messages, then something went wrong. MOST LIKELY IT IS BECAUSE:

1. The data to be inserted exceeds the length allocated for the data in your database creation file.

2. The data file contains data that you did not allocate a field for in your database creation file.

3. The Order of the fields you specified in your database creation file does not correspond to the data.

4. Some combination of the above.

To correct this, correct the Database Creation File, NOT the data file.

How will you know that it was correctly inserted? If you get the (on-screen) message "Record inserted", you will know that you correctly inserted the record. If you get the message "Relational Integrity Violation" (or something along those lines), something went wrong. We'll take a look at it in the lab. You will also know that everything went well if you see the acknowledgement:

200 rows inserted

CREATE SCHEMA
AUTHORIZATION kirs;
INSERT INTO physician VALUES ('123456789','Smith, Mary','Cardiology','123 Main St.','Arlington','TX','76019','');
INSERT INTO physician VALUES ('234567890','Jones, Jerry','Opthamology','55 Border St.','Arlington','TX','76022','');
INSERT INTO physician VALUES ('345678901','Seuss, Melvin','Orthopedics','999 Ham Ave','Ft. Worth','TX','74111','123456789');
INSERT INTO physician VALUES ('456789012','Crane, Frazier','Psychiatry','123 Main St.','Arlington','TX','76019','234567890');
INSERT INTO physician VALUES ('567890123','Crane, Niles','Dermatology','55443 Daphny St.','Seattle','WA','99221','123456789');
SELECT * FROM physician;
INSERT INTO patient VALUES ('987654321','Bush, George','555 6th St.','Austin','TX','43221','123456789');
INSERT INTO patient VALUES ('876543210','Gore, Al','2233 J Street','Washington','DC','11111','234567890');
INSERT INTO patient VALUES ('765432109','Perot, Ross','99 EDS Lane','Dallas','TX','79901','345678901');
INSERT INTO patient VALUES ('654321098','Clinton, Hilary','200 5th Ave.','New York','NY','10012','123456789');
INSERT INTO patient VALUES ('543210987','Clinton, Bill','690 State St.','Little Rock','AK','39221','234567890');
INSERT INTO patient VALUES ('432109876','Lieberman, Joe','761 Elm St.','Hartford','CN','22122','123456789');
INSERT INTO patient VALUES ('321098765','Cheney, Dick','111 Cooper St.','Los Angeles','CA','50505','123456789');
INSERT INTO patient VALUES ('210987654','Bush, Jeb','555 6th St.','Austin','TX','43221','123456789');
INSERT INTO patient VALUES ('109876543','Nader, Ralph','224 Green St.','New York','NY','10110','345678901');
INSERT INTO patient VALUES ('098765432','Bush, Barbara','555 6th St.','Austin','TX','43221','234567890');
INSERT INTO patient VALUES ('998877665','Gore, Tipper','2233 J Street','Washington','DC','11111','123456789');
INSERT INTO patient VALUES ('887766554','McPherson, Elle','100 Star St.','Los Angeles','CA','50502','123456789');
INSERT INTO patient VALUES ('776655443','Lopez, Jennifer','9012 Sorolla Ave.','Coral Gables','FL','33034','456789012');
INSERT INTO patient VALUES ('665544332','T, Ice','4210 Rap Ave.','Los Angeles','CA','50512','345678901');
INSERT INTO patient VALUES ('554433221','Smith, Emmitt','22 Back St.','Dallas','TX','64444','345678901');
INSERT INTO patient VALUES ('443322110','Smith, Bessie','1324 Blues St.','Memphis','TN','80212','234567890');
INSERT INTO patient VALUES ('332211009','Schumann, Clara','12 Ivory Street','New Orleans','LA','44432','345678901');
INSERT INTO patient VALUES ('221100998','Beethoven, L.V.','9 Symphony St.','Boston','MA','22661','567890123');
INSERT INTO patient VALUES ('110090887','Ross, Diana','678 Motown Street','Detroit','MI','72212','123456789');
INSERT INTO patient VALUES ('009988776','Lennon, John','211 W. Central Park','New York','NY','10021','345678901');
INSERT INTO patient VALUES ('019283746','Ono, Yoko','211 W. Central Park','New York','NY','10021','345678901');
INSERT INTO patient VALUES ('102938475','Shakespeare, Bill','198 Avon St.','New London','CN','22112','123456789');
INSERT INTO patient VALUES ('293847560','Marlowe, Chris','657 Picadilly St.','San Francisco','CA','33221','567890123');
INSERT INTO patient VALUES ('394857601','Curie, Marie','98 Nucleus Ave.','Chicago','IL','40029','456789012');
INSERT INTO patient VALUES ('564738291','Einstein, Al','7344 EMC2 St.','Princeton','NJ','31192','123456789');
INSERT INTO patient VALUES ('847560192','Pavlova, Anna','70 Pointe Lane','Moscow','ID','77653','123456789');
INSERT INTO patient VALUES ('758493026','Baryshnikov, Mike','76 Jump St.','El Paso','TX','79902','567890123');
INSERT INTO patient VALUES ('648392015','Pavorotti, Luciano','99 Aria Ave.','Venice Beach','CA','22110','456789012');
INSERT INTO patient VALUES ('567483920','Norman, Jessie','7720 Mozart Lane','Albuquerque','NM','44322','567890123');
SELECT * FROM patient;
INSERT INTO illness VALUES ('OBA1234567','Broken Left Arm');
INSERT INTO illness VALUES ('OBA2345678','Broken Right Arm');
INSERT INTO illness VALUES ('OBH3456789','Broken Finger');
INSERT INTO illness VALUES ('OBL1234567','Broken Left Leg');
INSERT INTO illness VALUES ('OBL2345678','Broken Right Leg');
INSERT INTO illness VALUES ('OBL3456789','Broken Right Toe');
INSERT INTO illness VALUES ('OBH4567890','Bruised Ego');
INSERT INTO illness VALUES ('OBH5678901','Broken Heart');
INSERT INTO illness VALUES ('OPT9876543','Bad Eyesight');
INSERT INTO illness VALUES ('OPT8765432','Really Bad Eyesight');
INSERT INTO illness VALUES ('OPT7654321','Almost Blind');
INSERT INTO illness VALUES ('OPT6543210','Blind as a Bat');
INSERT INTO illness VALUES ('SDO1234567','Hypochandria');
INSERT INTO illness VALUES ('SDO9654321','Simple Obnoxiousness');
INSERT INTO illness VALUES ('SDO7654321','Neurosis');
INSERT INTO illness VALUES ('SDO6543210','Psychosis');
INSERT INTO illness VALUES ('SDO5432109','Schizophrenia');
INSERT INTO illness VALUES ('SDO4321987','Bad Manners');
INSERT INTO illness VALUES ('SDO3219876','Bad Breath');
INSERT INTO illness VALUES ('IMH0011223','Heartlessness');
INSERT INTO illness VALUES ('IMH1122334','Mild Heart Attack');
INSERT INTO illness VALUES ('IMH2233445','Severe Heart Attack');
INSERT INTO illness VALUES ('IMH3344556','Ouch, That Hurts');
INSERT INTO illness VALUES ('IMH4455667','The Big One');
INSERT INTO illness VALUES ('IMH5566778','Severe Death');
INSERT INTO illness VALUES ('SKD1098765','Skin Irritation');
INSERT INTO illness VALUES ('SKD0987654','Dermatitis');
INSERT INTO illness VALUES ('SKD9876543','Acne');
INSERT INTO illness VALUES ('SKD8765432','Major Acne');
INSERT INTO illness VALUES ('SKD7654321','Man, thats bad skin');
SELECT * FROM illness;
INSERT INTO prescription VALUES ('XXX000000','None');
INSERT INTO prescription VALUES ('A11223344','Aspirin');
INSERT INTO prescription VALUES ('A22334455','Tylenol');
INSERT INTO prescription VALUES ('A33445566','Placebo');
INSERT INTO prescription VALUES ('A12344556','Bedrest');
INSERT INTO prescription VALUES ('A44556677','Cup of Tea');
INSERT INTO prescription VALUES ('A55667788','TLC');
INSERT INTO prescription VALUES ('A77889900','Expensive Stuff');
INSERT INTO prescription VALUES ('B12345678','Analgesic');
INSERT INTO prescription VALUES ('B23456789','Antibiotic');
INSERT INTO prescription VALUES ('B34567890','Retin-A');
INSERT INTO prescription VALUES ('B45678901','Retin-B');
INSERT INTO prescription VALUES ('B56789012','Anti-Inflam.');
INSERT INTO prescription VALUES ('B67890123','Anti-Establish.');
INSERT INTO prescription VALUES ('C99887766','Maalox');
INSERT INTO prescription VALUES ('C88776655','Dilaudin');
INSERT INTO prescription VALUES ('C77665544','Nitro Glycerin');
INSERT INTO prescription VALUES ('C66554433','Useless Stuff');
INSERT INTO prescription VALUES ('D10293847','Percodan');
INSERT INTO prescription VALUES ('D20394857','Opium');
INSERT INTO prescription VALUES ('D30495867','Codeine');
INSERT INTO prescription VALUES ('D40596871','Strong Stuff');
INSERT INTO prescription VALUES ('D50697812','Bad Stuff');
INSERT INTO prescription VALUES ('E98767543','Prozac');
INSERT INTO prescription VALUES ('E87675432','Double Prozac');
INSERT INTO prescription VALUES ('E76754321','Thorazine');
SELECT * FROM prescription;
INSERT INTO treatment VALUES ('443322110','OPT7654321','A33445566','- Aug -20/99');
INSERT INTO treatment VALUES ('776655443','SDO1234567','C66554433','- Aug -27/99');
INSERT INTO treatment VALUES ('876543210','OPT9876543','A44556677','- Sep -01/99');
INSERT INTO treatment VALUES ('765432109','SDO4321987','A33445566','- Sep -02/99');
INSERT INTO treatment VALUES ('654321098','OBH3456789','A11223344','- Sep -02/99');
INSERT INTO treatment VALUES ('998877665','SDO1234567','A11223344','- Sep -02/99');
INSERT INTO treatment VALUES ('998877665','SDO1234567','A33445566','- Sep -02/99');
INSERT INTO treatment VALUES ('998877665','SDO1234567','A77889900','- Sep -02/99');
INSERT INTO treatment VALUES ('998877665','SDO1234567','A55667788','- Sep -02/99');
INSERT INTO treatment VALUES ('432109876','OBH4567890','A12344556','- Sep -03/99');
INSERT INTO treatment VALUES ('765432109','SDO1234567','A77889900','- Sep -04/99');
INSERT INTO treatment VALUES ('765432109','SDO7654321','E98767543','- Sep -05/99');
INSERT INTO treatment VALUES ('776655443','SDO1234567','A12344556','- Sep -07/99');
INSERT INTO treatment VALUES ('776655443','SDO1234567','A11223344','- Sep -07/99');
INSERT INTO treatment VALUES ('776655443','SDO1234567','A77889900','- Sep -07/99');
INSERT INTO treatment VALUES ('665544332','SDO4321987','XXX000000','- Sep -10/99');
INSERT INTO treatment VALUES ('665544332','IMH3344556','XXX000000','- Sep -10/99');
INSERT INTO treatment VALUES ('665544332','IMH5566778','XXX000000','- Sep -10/99');
INSERT INTO treatment VALUES ('987654321','OBH4567890','E98767543','- Sep -20/99');
INSERT INTO treatment VALUES ('109876543','OBL3456789','A12344556','- Sep -20/99');
INSERT INTO treatment VALUES ('109876543','OBL3456789','A22334455','- Sep -20/99');
INSERT INTO treatment VALUES ('109876543','OBL3456789','A55667788','- Sep -20/99');
INSERT INTO treatment VALUES ('776655443','SDO7654321','E98767543','- Sep -27/99');
INSERT INTO treatment VALUES ('554433221','OBA1234567','A11223344','- Oct -01/99');
INSERT INTO treatment VALUES ('554433221','OBA1234567','A12344556','- Oct -01/99');
INSERT INTO treatment VALUES ('554433221','OBA1234567','A44556677','- Oct -01/99');
INSERT INTO treatment VALUES ('554433221','OBA1234567','A55667788','- Oct -01/99');
INSERT INTO treatment VALUES ('554433221','OBA1234567','A77889900','- Oct -01/99');
INSERT INTO treatment VALUES ('332211009','OBA2345678','A12344556','- Oct -07/99');
INSERT INTO treatment VALUES ('332211009','OBH3456789','XXX000000','- Oct -07/99');
INSERT INTO treatment VALUES ('009988776','OBA2345678','B12345678','- Oct -09/99');
INSERT INTO treatment VALUES ('765432109','SDO7654321','E87675432','- Oct -10/99');
INSERT INTO treatment VALUES ('543210987','OPT8765432','A44556677','- Oct -10/99');
INSERT INTO treatment VALUES ('321098765','IMH1122334','B23456789','- Oct -11/99');
INSERT INTO treatment VALUES ('210987654','SKD1098765','B34567890','- Oct -11/99');
INSERT INTO treatment VALUES ('009988776','OBA2345678','B56789012','- Oct -15/99');
INSERT INTO treatment VALUES ('009988776','OBA2345678','B67890123','- Oct -15/99');
INSERT INTO treatment VALUES ('210987654','SKD1098765','B34567890','- Oct -18/99');
INSERT INTO treatment VALUES ('210987654','SKD1098765','B45678901','- Oct -25/99');
INSERT INTO treatment VALUES ('098765432','OPT8765432','D10293847','- Oct -26/99');
INSERT INTO treatment VALUES ('654321098','OBH3456789','A11223344','- Nov -02/99');
INSERT INTO treatment VALUES ('432109876','OBH4567890','A11223344','- Nov -03/99');
INSERT INTO treatment VALUES ('321098765','IMH1122334','B23456789','- Nov -04/99');
INSERT INTO treatment VALUES ('009988776','OBA2345678','B56789012','- Nov -07/99');
INSERT INTO treatment VALUES ('102938475','OPT9876543','A11223344','- Nov -10/99');
INSERT INTO treatment VALUES ('102938475','OPT9876543','A12344556','- Nov -10/99');
INSERT INTO treatment VALUES ('102938475','OPT9876543','A77889900','- Nov -10/99');
INSERT INTO treatment VALUES ('998877665','SDO1234567','A55667788','- Nov -12/99');
INSERT INTO treatment VALUES ('998877665','SDO1234567','D20394857','- Nov -12/99');
INSERT INTO treatment VALUES ('998877665','SDO1234567','E98767543','- Nov -12/99');
INSERT INTO treatment VALUES ('654321098','OBH3456789','A55667788','- Nov -16/99');
INSERT INTO treatment VALUES ('332211009','OBH3456789','D30495867','- Nov -17/99');
INSERT INTO treatment VALUES ('654321098','OBH3456789','A77889900','- Nov -23/99');
INSERT INTO treatment VALUES ('432109876','SDO3219876','A11223344','- Nov -23/99');
INSERT INTO treatment VALUES ('654321098','OBH3456789','A77889900','- Dec -01/99');
INSERT INTO treatment VALUES ('887766554','SDO3219876','A77889900','- Dec -03/99');
INSERT INTO treatment VALUES ('887766554','SDO3219876','A44556677','- Dec -03/99');
INSERT INTO treatment VALUES ('887766554','SDO3219876','D30495867','- Dec -03/99');
INSERT INTO treatment VALUES ('765432109','SDO7654321','A77889900','- Dec -05/99');
INSERT INTO treatment VALUES ('765432109','SDO7654321','E98767543','- Dec -05/99');
INSERT INTO treatment VALUES ('765432109','SDO6543210','E76754321','- Dec -07/99');
INSERT INTO treatment VALUES ('210987654','SKD1098765','B67890123','- Dec -07/99');
INSERT INTO treatment VALUES ('987654321','OBH4567890','E87675432','- Dec -08/99');
INSERT INTO treatment VALUES ('321098765','IMH2233445','D30495867','- Dec -08/99');
INSERT INTO treatment VALUES ('321098765','IMH2233445','D50697812','- Dec -09/99');
INSERT INTO treatment VALUES ('987654321','OBH4567890','E76754321','- Dec -12/99');
INSERT INTO treatment VALUES ('098765432','OPT8765432','D10293847','- Dec -14/99');
INSERT INTO treatment VALUES ('332211009','OBH3456789','D30495867','- Dec -17/99');
INSERT INTO treatment VALUES ('554433221','OBA1234567','A77889900','- Dec -22/99');
INSERT INTO treatment VALUES ('554433221','OBA1234567','D30495867','- Dec -22/99');
INSERT INTO treatment VALUES ('654321098','OBH3456789','A77889900','- Jan -02/00');
INSERT INTO treatment VALUES ('876543210','OPT7654321','A77889900','- Jan -02/00');
INSERT INTO treatment VALUES ('654321098','OBH3456789','A77889900','- Jan -03/00');
INSERT INTO treatment VALUES ('543210987','OPT8765432','A44556677','- Jan -03/00');
INSERT INTO treatment VALUES ('109876543','OBL3456789','D30495867','- Jan -04/00');
INSERT INTO treatment VALUES ('543210987','OPT8765432','A44556677','- Jan -05/00');
INSERT INTO treatment VALUES ('564738291','OBL1234567','A44556677','- Jan -10/00');
INSERT INTO treatment VALUES ('564738291','OBL1234567','A12344556','- Jan -10/00');
INSERT INTO treatment VALUES ('564738291','OBL1234567','B56789012','- Jan -10/00');
INSERT INTO treatment VALUES ('564738291','OBL1234567','B23456789','- Jan -10/00');
INSERT INTO treatment VALUES ('564738291','OBL1234567','A77889900','- Jan -10/00');
INSERT INTO treatment VALUES ('564738291','OBL1234567','D30495867','- Jan -10/00');
INSERT INTO treatment VALUES ('998877665','SDO1234567','E98767543','- Jan -18/00');
INSERT INTO treatment VALUES ('998877665','SDO1234567','E76754321','- Jan -18/00');
INSERT INTO treatment VALUES ('887766554','SDO3219876','D30495867','- Jan -23/00');
INSERT INTO treatment VALUES ('765432109','SDO6543210','E76754321','- Jan -24/00');
INSERT INTO treatment VALUES ('110090887','IMH1122334','C88776655','- Jan -25/00');
INSERT INTO treatment VALUES ('564738291','OBL1234567','A77889900','- Jan -28/00');
INSERT INTO treatment VALUES ('564738291','OBL1234567','D30495867','- Jan -28/00');
INSERT INTO treatment VALUES ('009988776','SDO3219876','D10293847','- Feb -01/00');
INSERT INTO treatment VALUES ('009988776','SDO3219876','A77889900','- Feb -01/00');
INSERT INTO treatment VALUES ('765432109','SDO6543210','D30495867','- Feb -07/00');
INSERT INTO treatment VALUES ('987654321','OBH4567890','D30495867','- Feb -08/00');
INSERT INTO treatment VALUES ('321098765','IMH2233445','D50697812','- Feb -09/00');
INSERT INTO treatment VALUES ('210987654','SKD1098765','D30495867','- Feb -09/00');
INSERT INTO treatment VALUES ('432109876','SKD1098765','D30495867','- Feb -12/00');
INSERT INTO treatment VALUES ('098765432','OPT8765432','D10293847','- Feb -14/00');
INSERT INTO treatment VALUES ('564738291','OBL1234567','A77889900','- Feb -15/00');
INSERT INTO treatment VALUES ('564738291','OBL1234567','D30495867','- Feb -15/00');
INSERT INTO treatment VALUES ('221100998','SKD1098765','A33445566','- Feb -17/00');
INSERT INTO treatment VALUES ('009988776','SDO3219876','D50697812','- Feb -20/00');
INSERT INTO treatment VALUES ('102938475','OPT8765432','A77889900','- Feb -22/00');
INSERT INTO treatment VALUES ('102938475','OPT8765432','B23456789','- Feb -22/00');
INSERT INTO treatment VALUES ('394857601','SDO7654321','A11223344','- Feb -25/00');
INSERT INTO treatment VALUES ('758493026','SKD1098765','C66554433','- Feb -26/00');
INSERT INTO treatment VALUES ('221100998','SKD9876543','A11223344','- Mar -05/00');
INSERT INTO treatment VALUES ('221100998','SKD9876543','A55667788','- Mar -05/00');
INSERT INTO treatment VALUES ('221100998','SKD9876543','B23456789','- Mar -05/00');
INSERT INTO treatment VALUES ('110090887','IMH1122334','C77665544','- Mar -12/00');
INSERT INTO treatment VALUES ('110090887','IMH1122334','B56789012','- Mar -12/00');
INSERT INTO treatment VALUES ('110090887','IMH1122334','C66554433','- Mar -12/00');
INSERT INTO treatment VALUES ('758493026','SKD1098765','C66554433','- Mar -15/00');
INSERT INTO treatment VALUES ('564738291','OBL1234567','A77889900','- Mar -17/00');
INSERT INTO treatment VALUES ('564738291','OBL1234567','D30495867','- Mar -17/00');
INSERT INTO treatment VALUES ('987654321','OBH5678901','D30495867','- Mar -22/00');
INSERT INTO treatment VALUES ('210987654','SKD1098765','D30495867','- Mar -23/00');
INSERT INTO treatment VALUES ('758493026','SKD0987654','B34567890','- Mar -26/00');
INSERT INTO treatment VALUES ('758493026','SKD0987654','B56789012','- Mar -26/00');
INSERT INTO treatment VALUES ('394857601','SDO7654321','A11223344','- Mar -25/00');
INSERT INTO treatment VALUES ('394857601','SDO7654321','E98767543','- Mar -25/00');
INSERT INTO treatment VALUES ('098765432','OPT8765432','D30495867','- Mar -26/00');
INSERT INTO treatment VALUES ('102938475','OPT8765432','D30495867','- Mar -29/00');
INSERT INTO treatment VALUES ('758493026','SKD0987654','B45678901','- Apr -03/00');
INSERT INTO treatment VALUES ('758493026','SKD0987654','D30495867','- Apr -03/00');
INSERT INTO treatment VALUES ('110090887','IMH1122334','D30495867','- Apr -07/00');
INSERT INTO treatment VALUES ('765432109','SDO6543210','E76754321','- Apr -11/00');
INSERT INTO treatment VALUES ('654321098','OBH3456789','A77889900','- Apr -12/00');
INSERT INTO treatment VALUES ('321098765','IMH2233445','D50697812','- Apr -13/00');
INSERT INTO treatment VALUES ('009988776','SDO3219876','A22334455','- Apr -18/00');
INSERT INTO treatment VALUES ('009988776','SDO3219876','A77889900','- Apr -18/00');
INSERT INTO treatment VALUES ('210987654','SKD1098765','D30495867','- Apr -23/00');
INSERT INTO treatment VALUES ('394857601','SDO6543210','E87675432','- Apr -25/00');
INSERT INTO treatment VALUES ('998877665','IMH2233445','C77665544','- May -01/00');
INSERT INTO treatment VALUES ('998877665','IMH5566778','XXX000000','- May -01/00');
INSERT INTO treatment VALUES ('758493026','SKD7654321','D30495867','- May -03/00');
INSERT INTO treatment VALUES ('102938475','OPT8765432','D30495867','- May -05/00');
INSERT INTO treatment VALUES ('019283746','SDO9654321','A33445566','- May -07/00');
INSERT INTO treatment VALUES ('564738291','OBL1234567','A77889900','- May -10/00');
INSERT INTO treatment VALUES ('564738291','OBL1234567','D30495867','- May -10/00');
INSERT INTO treatment VALUES ('098765432','OPT8765432','D40596871','- May -17/00');
INSERT INTO treatment VALUES ('221100998','SKD9876543','B23456789','- May -18/00');
INSERT INTO treatment VALUES ('221100998','SKD9876543','D30495867','- May -18/00');
INSERT INTO treatment VALUES ('758493026','SKD7654321','D30495867','- May -16/00');
INSERT INTO treatment VALUES ('110090887','IMH1122334','D30495867','- May -20/00');
INSERT INTO treatment VALUES ('394857601','SDO6543210','E87675432','- May -25/00');
INSERT INTO treatment VALUES ('394857601','SDO6543210','C66554433','- May -25/00');
INSERT INTO treatment VALUES ('009988776','OPT9876543','B23456789','- May -28/00');
INSERT INTO treatment VALUES ('019283746','SDO4321987','E98767543','- Jun -01/00');
INSERT INTO treatment VALUES ('019283746','SDO4321987','A77889900','- Jun -01/00');
INSERT INTO treatment VALUES ('987654321','OBH4567890','D30495867','- Jun -10/00');
INSERT INTO treatment VALUES ('102938475','OPT8765432','D30495867','- Jun -12/00');
INSERT INTO treatment VALUES ('987654321','OBH4567890','C66554433','- Jun -14/00');
INSERT INTO treatment VALUES ('758493026','SKD7654321','D30495867','- Jun -16/00');
INSERT INTO treatment VALUES ('554433221','OBA1234567','D30495867','- Jun -22/00');
INSERT INTO treatment VALUES ('221100998','SKD8765432','D30495867','- Jun -24/00');
INSERT INTO treatment VALUES ('394857601','SDO5432109','E76754321','- Jun -25/00');
INSERT INTO treatment VALUES ('847560192','OBL3456789','B56789012','- Jun -28/00');
INSERT INTO treatment VALUES ('847560192','OBL3456789','D30495867','- Jun -28/00');
INSERT INTO treatment VALUES ('009988776','OPT9876543','B23456789','- Jul -04/00');
INSERT INTO treatment VALUES ('009988776','OPT9876543','C66554433','- Jul -04/00');
INSERT INTO treatment VALUES ('102938475','OPT6543210','D30495867','- Jul -09/00');
INSERT INTO treatment VALUES ('564738291','OBL1234567','A77889900','- Jul -10/00');
INSERT INTO treatment VALUES ('564738291','OBL1234567','D30495867','- Jul -10/00');
INSERT INTO treatment VALUES ('654321098','OBH3456789','A77889900','- Jul -12/00');
INSERT INTO treatment VALUES ('648392015','SDO7654321','A33445566','- Jul -18/00');
INSERT INTO treatment VALUES ('876543210','SDO4321987','D40596871','- Jul -21/00');
INSERT INTO treatment VALUES ('394857601','SDO5432109','E76754321','- Jul -25/00');
INSERT INTO treatment VALUES ('847560192','OBL3456789','D30495867','- Jul -28/00');
INSERT INTO treatment VALUES ('019283746','SDO4321987','A77889900','- Aug -01/00');
INSERT INTO treatment VALUES ('019283746','SDO4321987','E87675432','- Aug -01/00');
INSERT INTO treatment VALUES ('102938475','OPT6543210','D30495867','- Aug -08/00');
INSERT INTO treatment VALUES ('648392015','SDO7654321','A11223344','- Aug -10/00');
INSERT INTO treatment VALUES ('648392015','SDO7654321','A77889900','- Aug -10/00');
INSERT INTO treatment VALUES ('543210987','OPT7654321','D30495867','- Aug -11/00');
INSERT INTO treatment VALUES ('221100998','SKD7654321','D30495867','- Aug -15/00');
INSERT INTO treatment VALUES ('394857601','SDO5432109','E76754321','- Aug -25/00');
INSERT INTO treatment VALUES ('847560192','OBL3456789','D30495867','- Aug -26/00');
INSERT INTO treatment VALUES ('564738291','OBL1234567','A77889900','- Aug -28/00');
INSERT INTO treatment VALUES ('564738291','OBL1234567','D30495867','- Aug -28/00');
INSERT INTO treatment VALUES ('019283746','SDO4321987','E87675432','- Sep -01/00');
INSERT INTO treatment VALUES ('765432109','SDO7654321','E87675432','- Sep -08/00');
INSERT INTO treatment VALUES ('648392015','SDO7654321','E98767543','- Sep -10/00');
INSERT INTO treatment VALUES ('567483920','SKD8765432','B34567890','- Sep -12/00');
INSERT INTO treatment VALUES ('567483920','SKD8765432','B45678901','- Sep -12/00');
INSERT INTO treatment VALUES ('567483920','SKD8765432','B12345678','- Sep -12/00');
INSERT INTO treatment VALUES ('567483920','SKD8765432','B67890123','- Sep -12/00');
INSERT INTO treatment VALUES ('567483920','SKD8765432','B23456789','- Sep -12/00');
INSERT INTO treatment VALUES ('567483920','SKD8765432','D40596871','- Sep -12/00');
INSERT INTO treatment VALUES ('102938475','OPT6543210','D30495867','- Sep -15/00');
INSERT INTO treatment VALUES ('567483920','IMH5566778','XXX000000','- Sep -18/00');
INSERT INTO treatment VALUES ('293847560','SKD0987654','B34567890','- Sep -20/00');
INSERT INTO treatment VALUES ('293847560','SKD0987654','C66554433','- Sep -20/00');
INSERT INTO treatment VALUES ('394857601','SDO5432109','E76754321','- Sep -25/00');
INSERT INTO treatment VALUES ('648392015','SDO7654321','E87675432','- Sep -28/00');
INSERT INTO treatment VALUES ('987654321','OBH5678901','C66554433','- Oct -02/00');
INSERT INTO treatment VALUES ('876543210','SDO4321987','E76754321','- Oct -02/00');
INSERT INTO treatment VALUES ('648392015','SDO7654321','E76754321','- Oct -03/00');
INSERT INTO treatment VALUES ('654321098','OBH3456789','A77889900','- Oct -05/00');
INSERT INTO treatment VALUES ('432109876','SKD1098765','D10293847','- Oct -06/00');
INSERT INTO treatment VALUES ('321098765','IMH2233445','D50697812','- Oct -06/00');
SELECT * FROM treatment;

This page was last updated on 08/24/03