/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

3 votes352 views4 answers
Order by desc postgres
SQL
0 vote324 views1 answer
Não é possível executar uma operação DML dentro de uma consulta
SQL
0 vote321 views1 answer
Postgresql create table with boolean column
SQL
9 votes314 views3 answers
Mysql get last id
SQL
9 votes367 views3 answers
Postgres make sql dump
SQL
0 vote325 views1 answer
Retornar apenas o ano mysql date
SQL
0 vote314 views1 answer
Procedures and functions in pl/sql
SQL
0 vote370 views1 answer
How to fetch data from database in sql
SQL
-3 votes315 views1 answer
Remove spaces sql 2008
SQL
0 vote336 views1 answer
Postgresql array to rows
SQL