/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 vote213 views2 answers
Denormalization in sql
SQL
0 vote249 views1 answer
Create column that already exists mysql
SQL
0 vote260 views1 answer
Sql server remove enter from string
SQL
0 vote269 views1 answer
Pgsql is not permitted to log in
SQL
2 votes265 views1 answer
Get first 2 letter in sql
SQL
0 vote276 views2 answers
Py sqlite if entry exists
SQL
0 vote347 views1 answer
How to check common records in 2 table
SQL
2 votes266 views1 answer
Sql ends with string
SQL
0 vote273 views1 answer
Sql reverse order of results
SQL
0 vote273 views1 answer
Get enginge db mysql
SQL