/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

25 votes213 views4 answers
Import mysql dump command line
SQL
3 votes310 views1 answer
Sql add two values together
SQL
0 vote177 views2 answers
Postgres default user
SQL
0 vote192 views2 answers
Sql query for getting details by id
SQL
36 votes192 views3 answers
Finding duplicate column values in table with sql
SQL
13 votes241 views6 answers
Mysql remove duplicates
SQL
0 vote207 views1 answer
Sql show founctions
SQL
0 vote182 views1 answer
Create a view in sqlite
SQL
0 vote190 views1 answer
Restore backup mysql .gz
SQL
16 votes244 views6 answers
Insert sql
SQL