i want to get whick primary key act as forgein key in whick table by some joins by linking parent table with child and applying constraints;


this query gives me some info about forign keys with column ids but not linked with which primary keys of parent table ;

SELECT * FROM ALL_CONS_COLUMN S A JOIN ALL_CONSTRAINTS C ON A.CONSTRAINT_NA ME = C.CONSTRAINT_NA ME
WHERE C.TABLE_NAME = 'STUDENT_COURSE '
AND...