SELECT
UC.TABLE_NAME
, UC.R_CONSTRAINT_NAME
, UCC.TABLE_NAME
, UCC.COLUMN_NAME
FROM
USER_CONSTRAINTS UC
, USER_CONS_COLUMNS UCC
WHERE
UC.R_CONSTRAINT_NAME = UCC.CONSTRAINT_NAME
AND UC.CONSTRAINT_TYPE = 'R'
AND UCC.TABLE_NAME = '테이블명';