Description
I WILL PROVIDE A PICTURE OF THE QUESTION SO IT IS CLEARER AS WELLThere 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) 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.
1 attachmentsSlide 1 of 1attachment_1attachment_1
Explanation & Answer:
1 Page
User generated content is uploaded by users for the purposes of learning and should be used following Studypool’s honor code & terms of service.