[Oracle] 특정 테이블과 연결된 모든 테이블 목록 조회

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 = '계정명' 
   AND fk.CONSTRAINT_TYPE = 'R'
   AND pk.TABLE_NAME = '테이블명'
 ORDER BY fk.TABLE_NAME