SELECT
CON.CONSTRAINT_NAME COL_NAME,
CON.TABLE_NAME FK_TABLE,
COL.COLUMN_NAME FK_COL,
COLFK.TABLE_NAME PK_TABLE,
COLFK.COLUMN_NAME PK_COL
FROM
USER_CONSTRAINTS CON, USER_CONS_COLUMNS COL,
USER_CONS_COLUMNS COLFK
WHERE
CON.CONSTRAINT_TYPE = 'R'
AND CON.CONSTRAINT_NAME = COL.CONSTRAINT_NAME
AND CON.R_CONSTRAINT_NAME = COLFK.CONSTRAINT_NAME
/