/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 vote189 views1 answer
Conda install pymysql "windows"
SQL
1 vote186 views1 answer
Sometimes i cant edit sql developer
SQL
0 vote182 views1 answer
Mysql in clausule string array
SQL
0 vote188 views1 answer
Sql change default collation to utf8
SQL
0 vote185 views1 answer
Oracle query to see what scema i am working in
SQL
0 vote220 views1 answer
Sqlalchemy empty table
SQL
-1 vote280 views5 answers
Left join
SQL
1 vote250 views1 answer
Ora-01950 no privileges on tablespace
SQL
0 vote199 views1 answer
Oracle string substitution
SQL
0 vote192 views2 answers
How to use aggregate functions in sql
SQL