COL TABLE FORMAT A10 ON
COL REFERS FORMAT A10 ON
COL FOREIGN_KEY FORMAT A15 ON
COL REF_KEY FORMAT A15 ON
SELECT A.TABLE_NAME "TABLE",
 A.CONSTRAINT_NAME "FORIEGN_KEY",
A.R_CONSTRAINT_NAME "REF_KEY",
B.TABLE_NAME "REFERS"
FROM USER_CONSTRAINTS A, USER_CONSTRAINTS B
WHERE
A.R_CONSTRAINT_NAME=B.CONSTRAINT_NAME
AND B.CONSTRAINT_TYPE = 'P'
AND A.TABLE_NAME = '&TABLE'
/
COL TABLE OFF
COL REFERS OFF