Purdue University Fort WaynePL/SQL Worksheet

I WILL PROVIDE A PICTURE OF THE QUESTION SO IT IS CLEARER AS WELL

There are three tables students1, students2 and students3 with different schemas. However, they have two common columns called Name and SSN. The datatypes of Name and SSN are the same in these three tables. A given student is represented in only one of the tables students1, students2 and students3. However, it is not known which table will contain information of this student.

Write a PL/SQL block (either an anonymous PL/SQL block or a function or procedure) thatwill display the student name as well as the name of the table containing information of thisstudent when the SSN of this student is supplied to this PL/SQL block when it is called.

Question #6: There are three tables students1, students2 and students3 with different
schemas. However, they have two common columns called Name and SSN. The datatypes of
Name and SSN are the same in these three tables. A given student is represented in only one
of the tables students1, students 2 and students 3. However, it is not known which table will
contain information of this student.
Write a PL/SQL block (either an anonymous PL/SQL block or a function or procedure) that
will display the student name as well as the name of the table containing information of this
student when the SSN of this student is supplied to this PL/SQL block when it is called.