/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 vote204 views1 answer
Sql remove decimal places
SQL
0 vote215 views1 answer
Convert uniqueidentifier to varchar in sql
SQL
0 vote263 views1 answer
Run docker container with database as rds metabase
SQL
11 votes208 views4 answers
MYSQL LOGIN
SQL
0 vote203 views2 answers
Get all index postgres
SQL
2 votes172 views1 answer
Latest record in sql
SQL
0 vote198 views1 answer
Sql server current time without date
SQL
0 vote210 views1 answer
Mysql multiple count
SQL
0 vote197 views1 answer
How to select only id where is not in column mysql
SQL
0 vote206 views1 answer
Modificar tipo de dato sql server
SQL