I am using oracle database.
Is there a way I can check if the primary key value in one table is being used as a foreign key value (have any associations) in any other table?
Example: if I have the Student_id as primary key in STUDENT table. And there are other tables in the schema like CLASS, MARKS, SPORTS etc.
I have student_id=100 with me. I need to find out all the references of this student_id value '100' in the entire schema wherever it is linked as a foreign key from the parent table STUDENT.