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 vote335 views3 answers
Join
SQL
0 vote321 views1 answer
Difference between 2 query results sql server
SQL
0 vote341 views1 answer
Oracle sql how to overcome 999 limit for IN
SQL
0 vote328 views2 answers
Uninstall postgresql mac
SQL
1 vote313 views1 answer
Show indices in mysql table
SQL
7 votes394 views2 answers
Drop index oracle
SQL
1 vote354 views1 answer
Create new table from old table
SQL
0 vote322 views1 answer
Https://www.jitendrazaa.com/blog/sql/sqlserver/export-documents-saved-as-blob-binary-from-sql-server/
SQL
-1 vote316 views1 answer
Sql oracle take only last results
SQL
6 votes306 views6 answers
Code: 'ER_NOT_SUPPORTED_AUTH_MODE', errno: 1251, sqlMessage: 'Client does not support authentication protocol requested by server; consider upgrading MySQL client', sqlState: '08004', fatal: true
SQL