COL REFERRING_TABLE  FORM A20 ON
COL FOREIGN_KEY FORM A20 ON
COL REFERRED_TABLE FORM A20 ON
COL REF_KEY FORM A20 ON
SET VER OFF
SET ECHO OFF
 PROMPT "TABLES WHICH REFER TO THE GIVEN TABLENAME ARE:"

SELECT A.TABLE_NAME "REFERRING_TABLE",A.CONSTRAINT_NAME "FOREIGN_KEY",
B.TABLE_NAME "REFERRED_TABLE",A.R_CONSTRAINT_NAME "REF_KEY", A.STATUS 
FROM USER_CONSTRAINTS A,
USER_CONSTRAINTS B
WHERE A.R_CONSTRAINT_NAME = B.CONSTRAINT_NAME
AND B.TABLE_NAME = '&TABLENAME'
/
SET VER ON