PLEASE USE THESE TABLES, JUST COPY THE WHOLE THING THANKYOU, INSERT INTO DOCTOR VALUES(432, 'Harrison', TO_DATE('05-DEC-94'), 12000, 'Pediatrics', 100, 75, 4500); INSERT INTO DOCTOR VALUES(509, 'Vester', TO_DATE('09-JAN-00'), 8100, 'Pediatrics', 432, 40 , nulli); INSERT INTO DOCTOR VALUES(389, 'Lewis', TO_DATE('21-JAN-96'), 10000, 'Pediatrics', 432, 40, 2250); INSERT INTO DOCTOR VALUES(504, 'Cotner', TO_DATE('16-JUN-98'), 11500, 'Neurology', 289, 85, 7500); INSERT INTO DOCTOR VALUES(235, 'Smith', TO_DATE('22-JUN-98'), 4550, 'Family Practice', 100, 25, 2250); INSERT INTO DOCTOR VALUES(356, 'James', TO_DATE('O1-AUG-98'), 7950, 'Neurology', 289, 80, 6500); INSERT INTO DOCTOR VALUES(558, 'James', TO_DATE('O2-MMAY-95'), 9800, 'Orthopedics', 876, 85, 7700); INSERT INTO DOCTOR VALUES(876, 'Robertson', TO_DATE('O2-MAR-95'), 10500, 'Orthopedics', 100, 90, 8900); INSERT INTO DOCTOR VALUES(889, 'Thompson', TO_DATE('18-MAR-97'), 6500, 'Rehab', 100, 65, 3200); INSERT INTO DOCTOR VALUES(239, 'Pronger', TO_DATE('18-DEC-99'), 3500, 'Rehab',889, 40, null); INSERT INTO DOCTOR VALUES(289, 'Borque' , TO_DATE('30-JUN-89'), 16500, 'Neurology', 100, 95, 6500); INSERT INTO DOCTOR VALUES(100, 'Stevenson' , TO_DATE('30-JUN-79'), 23500, 'Director', null,null,null ); INSERT INTO BILLING VALUES(168, 15650, TO_DATE('21-AUG-01'), '833-9569', '128 W. Apple \#4', 'Jonesboro', 'IL', '62952', 'SIH'); INSERT INTO BILLING VALUES(331, 300, TO_DATE('09-SEP-01'), '833-5587', '3434 Mulberry St.', 'Anna', 'IL', '62906', 'BCBS'); INSERT INTO BILLING VALUES(313, 0, TO_DATE('01-JAN-02'), '893-9987', '334 Tailgate Ln', 'COBDEN', 'IL', '62920', 'Military'); INSERT INTO BILLING VALUES(816, 0, TO_DATE('01-JAN-02'), '833-6654', '8814 W. Apple ', 'JONESBORO', 'IL', '62952', 'SIH'); INSERT INTO BILLING VALUES(314, 100, TO_DATE('31-MAR-01'), '457-6658', '445 Oak St.', 'Carbondale', 'IL', '62901', 'BCBS'); INSERT INTO BILLING VALUES(264, 35000, TO_DATE('11-JAN-01'), '942-8065', '8898 Bighill Drive', 'HERRIN', 'IL', '62948', 'MediSupplA'); INSERT INTO BILLING VALUES(103, 4500, TO_DATE('O1-JUL-01'), '833-5547', '298 Murphy School Rd', 'Anna', 'IL', '62906', 'HealthCare'); INSERT INTO BILLING VALUES(108, 0, TO_DATE('01-JAN-03'), '833-5542', '334 Pansie Hill Rd.', 'JONESBORO', 'IL', '62952', 'HealthCare'); INSERT INTO BILLING VALUES(943, 0, TO_DATE('O1-JAN-05'), '529-9963', '456 E. Grand \#14', 'Carbondale', 'IL', '62901', 'Military'); INSERT INTO BILLING VALUES(847, 98000, TO_DATE('31-JAN-00'), '549-8854', '6543 W. Parkview Ln.', 'Carbondale', 'IL', '62901', 'BCBS'); INSERT INTO BILLING VALUES(504, 0, TO_DATE('O1-JAN-01'), '549-6139', '6657 N. Allen', 'Carbondale', 'IL', '62901', 'QualityCare'); INSERT INTO BILLING VALUES(809, 450, TO_DATE['19-JUL-01'), '687-8852', '3345 Hwy 127 N.', 'Murphysboro', 'IL', '62966', 'QualityCare'); INSERT INTO BILLING VALUES(703, 225, TO_DATE['31-AUG-01'), '529-8332', '909 N. Brown St.', 'Carbondale', 'IL', '62901', 'HealthCare'); INSERT INTO BILLING VALUES(696, 79850, TO_DATE('15-JUL-01'), '549-7231', '5546 W. James', 'Carbondale', 'IL', '62901', 'BCBS'); INSERT INTO BILLING VALUES(966, 98700, TO_DATE('15-JUL-01'), '833-5375', '9009 Taylor Ave.', 'Anna', 'IL', '62906', 'BCBS'); INSERT INTO BILLING VALUES(267, 0, TO_DATE('O1-JAN-03'), '942-3321', '6755 US Route 148', 'HERRIN', 'IL', '62948', 'QualityCare'); INSERT INTO BILLING VALUES(307, 450, TO_DATE('31-AUG-01'), '457-6967', '234 N. Allen', 'Carbondale', 'IL', '62901', 'HealthCare'); INSERT INTO BILLING VALUES(719, 0, TO_DATE('01-JAN-02'), '549-7848', '867 Henderson St.', 'Carbondale', 'IL', '62901', 'HealthCare'); INSERT INTO BILLING VALUES(439, 500, TO_DATE('31-AUG-01'), '833-5541', '4456 N.Springer', 'Anna', 'IL', '62906', 'QualityCare'); INSERT INTO BILLING VALUES(315, 1500, TO_DATE('14-SEP-01'), '833-6272', '404 Williford Rd.', 'JONESBORO', 'IL', '62952', 'HealthCare'); INSERT INTO BILLING VALUES(163, 0, TO_DATE('01-JAN-02'), '833-2133', '129 Fountain St.', 'Anna', 'IL', '62906', 'HealthCare'); INSERT INTO BILLING VALUES(669, 128450, TO_DATE('15-JUL-01'), '833-6654', '353 Tin Bender Rd.', 'Jonesboro', 'IL', '62952', 'BCBS'); INSERT INTO patient VALUES(168, 'James', 'Paul', TO_DATE('14-MAR-97'), 432, TO_DATE('O1-JUL-03'), TO_DATE('O1-JUN-03')); INSERT INTO patient VALUES(331, 'Anderson', 'Brian', TO_DATE('O6-MAR-48'), 235, TO_DATE('O1-JUL-03'), TO_DATE('O1-JUN-03')); INSERT INTO patient VALUES(313, 'James', 'Scott', TO_DATE('O1-MAR-33'), 235, TO_DATE('20-JUL-03'), TO_DATE('20-JUN-03')); INSERT INTO patient VALUES(816, 'Smith', 'Jason', TO_DATE('12-DEC-99'), 509, TO_DATE('15-NOV-03'), TO_DATE('15-MAY-03')); INSERT INTO patient VALUES(314, 'Porter', 'Susan', TO_DATE('14-NOV-67'), 235, TO_DATE('01-OCT-03'), TO_DATE('O1-MAR-03')); INSERT INTO patient VALUES(315, 'Saillez', 'Debbie', TO_DATE('09-SEP-55'), 235, TO_DATE('O1-JUL-03'), TO_DATE('O1-JUN-03')); INSERT INTO patient VALUES(719, 'Rogers', 'Anthony', TO_DATE('07-DEC-41'), 504, TO_DATE('O1-NOV-03'), TO_DATE('O1-JAN-03')); INSERT INTO patient VALUES(264, 'Walters', 'Stephanie', TO_DATE('01-JAN-45'), 504, TO_DATE('12-DEC-03'), TO_DATE('12-DEC-02')); INSERT INTO patient VALUES(267, 'Westra', 'Lynn', TO_DATE('12-JUL-57'), 235, TO_DATE('O2-FEB-04'), TO_DATE('O2-FEB-03')); INSERT INTO patient VALUES(103, 'Poole', 'Jennifer', TO_DATE('13-MAY-02'), 389, TO_DATE('O1-DEC-03'), TO_DATE('O1-JUN-03')); INSERT INTO patient VALUES(108, 'Baily', 'Ryan', TO_DATE('25-DEC-77'), 235, TO_DATE('06-JUN-05'), TO_DATE('06-JUN-03')); INSERT INTO patient VALUES(943, 'Crow', 'Lewis', TO_DATE('16-OCT-49'), 235, TO_DATE('01-JUL-05'), TO_DATE('O1-MAR-02')); INSERT INTO patient VALUES(847, 'Cochran', 'John', TO_DATE['O3-MAR-48'), 356, TO_DATE('02-DEC-05'), TO_DATE('O1-JAN-02')); INSERT INTO patient VALUES(163, 'Roach', 'Becky', TO_DATE('08-SEP-75'), 235, TO_DATE('O1-DEC-05'), TO_DATE('O1-JAN-02')); INSERT INTO patient VALUES(504, 'Jackson', 'John', TO_DATE('14-OCT-43'), 235, TO_DATE('21-JUL-03'), TO_DATE('10-NOV-02')); INSERT INTO patient VALUES(809, 'Kowalczyk', 'Paul', TO_DATE('12-NOV-51'), 558, TO_DATE('29-JUL-03'), TO_DATE('19-JUN-03')); INSERT INTO patient VALUES(703, 'Davis', 'Linda', TO_DATE('17-JUL-02'), 509, TO_DATE('21-JUL-03'), TO_DATE('22-MAY-03')); INSERT INTO patient VALUES(307, 'Jones', 'J.C.', TO_DATE('17-JUL-02'), 509, TO_DATE('21-JUL-03'), TO_DATE('22-MAY-03')); INSERT INTO patient VALUES(439, 'Wright', 'Chasity', TO_DATE('23-APR-73'), 235, TO_DATE("), TO_DATE(")); INSERT INTO patient VALUES(696, 'Vanderchuck', 'Keith', TO_DATE('08-AUG-68'), 504, TO_DATE("'), TO_DATE('15-JUN-03')); INSERT INTO patient VALUES(966, 'Mcginnis', 'Allen', TO_DATE('O3-MAY-59'), 504, TO_DATE("), TO_DATE('15-JUN-03')); INSERT INTO patient VALUES(669, 'Sakic', 'Joe', TO_DATE('16-SEP-76'), 504, TO_DATE("), TO_DATE('15-JUN-03')); THE QUESTION 2. Create a PL/SQL procedure that modifies the next date of appointment of certain patient. Call the procedure from anonymous block to allow the user to enter the patient's first name, last name, date of birth and the new date of appointment. If the following data is used, the output will be as follows. Enter the first name: Lewis Enter the last name: Crow Enter the date of birth: 16-OCT-49 Enter the new appointment date: 12-Jan-2012 The data has been updated. The original next appointment date was 01-JUL-05 PL/SQL procedure successfully completed