/SQL/Oracle find foreign key dependencies

Oracle find foreign key dependencies

SELECT c.OWNER, a.TABLE_NAME, a.COLUMN_NAME, a.CONSTRAINT_NAME, 
       c.R_OWNER AS REF_OWNER, cpk.TABLE_NAME AS REF_TABLE, 
       cpk.CONSTRAINT_NAME AS REF_PK
FROM ALL_CONS_COLUMNS a 
JOIN ALL_CONSTRAINTS c ON a.OWNER = c.OWNER
    AND a.CONSTRAINT_NAME = c.CONSTRAINT_NAME
 JOIN ALL_CONSTRAINTS cpk ON c.R_OWNER = cpk.OWNER
    AND c.R_CONSTRAINT_NAME = cpk.CONSTRAINT_NAME
WHERE c.CONSTRAINT_TYPE = 'R' AND c.TABLE_NAME= 'table_name';

Similar codes

0 vote237 views1 answer
Sql count matching group by
SQL
9 votes256 views6 answers
Check constraint in sql
SQL
0 vote273 views1 answer
For select oracle
SQL
0 vote229 views1 answer
Automatically update database last seen datetime in sql
SQL
1 vote238 views1 answer
Mysql data from file
SQL
-1 vote230 views1 answer
Mysql delete duplicate rows except one
SQL
1 vote258 views3 answers
How to reset id column in sql server
SQL
0 vote219 views1 answer
Pl sql search saurce code
SQL
0 vote219 views1 answer
Sql right characters
SQL
1 vote252 views1 answer
Key validation sql
SQL