FK 로 참조되는 테이블

외부키/FK 로 참조되는 테이블 조회

SELECT fk.owner, fk.constraint_name , fk.table_name 
  FROM all_constraints fk
     , all_constraints pk 
 WHERE fk.R_CONSTRAINT_NAME = pk.CONSTRAINT_NAME 
   AND pk.owner = 'HUNELEHR' 
   AND fk.CONSTRAINT_TYPE = 'R'
   AND pk.TABLE_NAME = 'PA1010'
 ORDER BY fk.TABLE_NAME