INFO 2303 Database ProgramingAssignment # : PL/SQL Procedure & Function Practice Note: PL/SQL can be executed in SQL*Plus or SQL Developer or Oracle Live SQL. Write a function that takes patient date of birth. If the patient born after 30th June 1990 then he/she will be required to set appointment for immunization. Call this function from anonymous block to allow the user to enter the patient ID. Expected output:Enter the patient ID: 168The status of X-immunization : REQUIRED CREATE TABLE PATIENT(PT_IDPT LNAMEPT FNAMEPTDOBDOC IDNEXTAPPTDATENUMBER(3),VARCHAR2(15),VARCHAR2(15),DATE,NUMBER(3).DATE,DATE,LASTAPPTDATECONSTRAINT PATIENT_PT_ID PK PRIMARY KEY(PT_ID),CONSTRAINT PATIENT_DOC_ID_FK FOREIGNKEY(DOC_ID)REFERENCES DOCTOR);INSERT INTO patient VALUES(168, James', "Paur.TO DATE('14-MAR-97'), 432.TO DATE(01-JUL-03'), TO DATE(01-JUN-03'):INSERT INTO patient VALUES(331, 'Anderson', 'Brian',TO DATE(06-MAR-48'), 235.TO DATE(01-JUL-03'). TO DATE(01-JUN-03')):INSERT INTO patient VALUES(313, James', "Scott.TO DATE(01-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-0CT-03). TO DATE(01-MAR-03'):INSERT INTO patient VALUES(315. 'Saillez', "Debbie',TO DATE(09-SEP-55'), 235,TO DATE(01-JUL-03'). TO_DATE(01-JUN-03'):INSERT INTO patient VALUES(719, "Rogers', "Anthony.TO DATE(07-DEC-41). 504.TO DATE(01-NOv-03), TO DATE(01-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(02-FEB-04'), TO DATE(02-FEB-03')):INSERT INTO patient VALUES(103, Poole', "Jennifer,TO DATE('13-MAY-02'), 389,TO DATE(01-DEC-03'), TO DATE(01-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(01-MAR-02);INSERT INTO patient VALUES(847, 'Cochran', "John',TO DATE('03-MAR-48'), 356.TO DATE(02-DEC-05), TO DATE(01-JAN-02'):INSERT INTO patient VALUES(163, Roach', "Becky',TO DATE('08-SEP-75'), 235,TO DATE(01-DEC-05), TO DATE(01-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'), 509TO 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, 'Moginnis', 'Allen',TO DATE('03-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')): 4. Write a function that takes patient date of birth. If the patient bornafter 30h June 1990 then he/she will be required to set appointmentfor immunization. Call this function from anonymous block to allowthe user to enter the patient ID.Expected output:Enter the patient ID: 168The status of X-immunization : REQUIRED

Question

INFO 2303 Database ProgramingAssignment # : PL/SQL Procedure & Function Practice Note: PL/SQL can be executed in SQL*Plus or SQL Developer or Oracle Live SQL. Write a function that takes patient date of birth. If the patient born after 30th June 1990 then he/she will be required to set appointment for immunization. Call this function from anonymous block to allow the user to enter the patient ID. Expected output:Enter the patient ID: 168The status of X-immunization : REQUIRED CREATE TABLE PATIENT(PT_IDPT LNAMEPT FNAMEPTDOBDOC IDNEXTAPPTDATENUMBER(3),VARCHAR2(15),VARCHAR2(15),DATE,NUMBER(3).DATE,DATE,LASTAPPTDATECONSTRAINT PATIENT_PT_ID PK PRIMARY KEY(PT_ID),CONSTRAINT PATIENT_DOC_ID_FK FOREIGNKEY(DOC_ID)REFERENCES DOCTOR);INSERT INTO patient VALUES(168, James', &#34;Paur.TO DATE('14-MAR-97'), 432.TO DATE(01-JUL-03'), TO DATE(01-JUN-03'):INSERT INTO patient VALUES(331, 'Anderson', 'Brian',TO DATE(06-MAR-48'), 235.TO DATE(01-JUL-03'). TO DATE(01-JUN-03')):INSERT INTO patient VALUES(313, James', &#34;Scott.TO DATE(01-MAR-33'). 235.TO DATE(20-JUL-03'). TO DATE(20-JUN-03'):INSERT INTO patient VALUES(816, 'Smith', &#34;Jason',TO DATE('12-DEC-99), 509.TO DATE('15-NOv-03). TO DATE('15-MAY-03'):INSERT INTO patient VALUES(314, Porter, &#34;Susan',TO DATE('14-NOV-67), 235.TO DATE(01-0CT-03). TO DATE(01-MAR-03'):INSERT INTO patient VALUES(315. 'Saillez', &#34;Debbie',TO DATE(09-SEP-55'), 235,TO DATE(01-JUL-03'). TO_DATE(01-JUN-03'):INSERT INTO patient VALUES(719, &#34;Rogers', &#34;Anthony.TO DATE(07-DEC-41). 504.TO DATE(01-NOv-03), TO DATE(01-JAN-03'):INSERT INTO patient VALUES(264, Walters', &#34;Stephanie&#34;,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(02-FEB-04'), TO DATE(02-FEB-03')):INSERT INTO patient VALUES(103, Poole', &#34;Jennifer,TO DATE('13-MAY-02'), 389,TO DATE(01-DEC-03'), TO DATE(01-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(01-MAR-02);INSERT INTO patient VALUES(847, 'Cochran', &#34;John',TO DATE('03-MAR-48'), 356.TO DATE(02-DEC-05), TO DATE(01-JAN-02'):INSERT INTO patient VALUES(163, Roach', &#34;Becky',TO DATE('08-SEP-75'), 235,TO DATE(01-DEC-05), TO DATE(01-JAN-02):INSERT INTO patient VALUES(504, 'Jackson', &#34;John',TO DATE('14-OCT-43'), 235.TO DATE('21-JUL-03'). TO DATE(10-NOV-02'):INSERT INTO patient VALUES(809, Kowalczyk', &#34;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'), 509TO 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, &#34;Chasity,TO DATE(23-APR-73), 235,TO_DATE(&#34;), TO DATE(&#34;):INSERT INTO patient VALUES(696, Vanderchuck', Keith',TO DATE(08-AUG-68').504, TO DATE(&#34;). TO_DATE(15-JUN-03):INSERT INTO patient VALUES(966, 'Moginnis', 'Allen',TO DATE('03-MAY-59), 504,TO DATE(&#34;). TO DATE(15-JUN-03'):INSERT INTO patient VALUES(669, 'Sakic', 'Joe',TO DATE('16-SEP-76'), 504,TO DATE(&#34;). TO_DATE(15-JUN-03')): 4. Write a function that takes patient date of birth. If the patient bornafter 30h June 1990 then he/she will be required to set appointmentfor immunization. Call this function from anonymous block to allowthe user to enter the patient ID.Expected output:Enter the patient ID: 168The status of X-immunization : REQUIRED

Accepted Answer

What is SQL?

SQL stands for Structured Query Language
SQL lets you access and manipulate databases…