table referenced by

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

--
http://www.freelists.org/webpage/oracle-l

Other related posts: