/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 vote246 views1 answer
Mysql auto increment default value with prefix month and year
SQL
0 vote254 views1 answer
This week mysql
SQL
1 vote265 views2 answers
Pad zero sql server
SQL
0 vote250 views1 answer
Aktor yang pernah terlibat di film bergenre Aksi di sql
SQL
2 votes258 views1 answer
Find all triggers in database
SQL
2 votes252 views1 answer
Sqlite insert if not exists
SQL
8 votes235 views1 answer
Sql remove characters from string right
SQL
0 vote237 views1 answer
Mysql select row with min date
SQL
2 votes282 views1 answer
Install postgresql centos 5
SQL
1 vote262 views1 answer
Backup mysql data only
SQL