/SQL/Query to find object dependencies in oracle

Query to find object dependencies in oracle

-- Dependencies on a view, table, ...
SELECT *
  FROM ALL_DEPENDENCIES			-- or DBA_DEPENDENCIES or USER_DEPENDENCIES
 WHERE TYPE = 'VIEW'			-- or 'PROCEDURE', 'SYNONYM'...
   AND REFERENCED_OWNER = 'OBJECT_OWNER'
   AND REFERENCED_NAME = 'OBJECT_NAME';

Similar codes

7 votes342 views3 answers
Postgresql dump and restore db
SQL
0 vote326 views1 answer
Mysql repair a table
SQL
23 votes336 views2 answers
Query to delete a database in mysql
SQL
0 vote406 views1 answer
Mysql get nested records
SQL
0 vote283 views1 answer
FindAllBy
SQL
7 votes312 views1 answer
Query delete duplicates
SQL
0 vote339 views1 answer
Display all node label neo4j
SQL
0 vote354 views1 answer
Hue hive UploadingTextFiletoHive
SQL
0 vote330 views1 answer
Setval in postgres
SQL
28 votes344 views6 answers
Foreign key
SQL