/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

0 vote206 views1 answer
Update All tables COLLATE DATABASE_DEFAULT
SQL
0 vote210 views1 answer
Prodection ready postgres database step by step
SQL
0 vote254 views1 answer
What is common table expression in sql
SQL
3 votes268 views1 answer
Query less than datetime sql
SQL
0 vote191 views1 answer
Hibernate xml property MySQL url, username and password
SQL
6 votes243 views1 answer
Identify primary key in oracle table
SQL
8 votes200 views1 answer
Today minus 15 days postgresql
SQL
0 vote210 views1 answer
Check if database exists sql
SQL
1 vote202 views1 answer
Temp table vs variable table in sql server
SQL
6 votes283 views1 answer
How to count number of rows in sql
SQL