table referenced by
- From: jo <jose.soares@xxxxxxxxxxxxxx>
- To: ORACLE-L <oracle-l@xxxxxxxxxxxxx>
- Date: Sat, 28 Apr 2012 21:04:30 +0200
Hi all,
I'm trying to create a query to know which tables are linked with table
'anagrafica'
in PostgreSQL I can achieve it with this query:
SELECT 'anagrafica' AS table,
conrelid::pg_catalog.regclass AS referenced_by,
conname AS foreignkey_name
FROM pg_catalog.pg_constraint c
WHERE c.contype = 'f'
AND c.confrelid = (
SELECT c.oid FROM pg_catalog.pg_class c
LEFT JOIN pg_catalog.pg_namespace n ON n.oid = c.relnamespace
WHERE c.relname = 'anagrafica' AND
pg_catalog.pg_table_is_visible(c.oid)
)
table | referenced_by | foreignkey_name
------------+--------------------------+----------------------------------------------------
anagrafica | asl | asl_id_anagrafica_fkey
anagrafica | azienda | azienda_id_anagrafica_fkey
Is it possible to do do the same thing in Oracle?
j
--
//www.freelists.org/webpage/oracle-l
Other related posts: