Oracle get foreign keys on table

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 vote127 views2 answers
Sql select inside select
SQL
0 vote141 views1 answer
Authentication modes in sql server
SQL
0 vote84 views1 answer
Sql count how many times a value appears
SQL
0 vote127 views1 answer
ORA-13717
SQL
0 vote135 views2 answers
Sqlalchemy default value for column
SQL
0 vote123 views2 answers
How to update date in oracle
SQL
0 vote80 views2 answers
Denormalization in sql
SQL
0 vote134 views1 answer
Unique index in mysql
SQL
3 votes111 views1 answer
Oracle nextval
SQL
0 vote136 views2 answers
Nodejs mysql convert to plain object
SQL