/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

4 votes129 views2 answers
Mysql show indexes on table
SQL
2 votes119 views1 answer
Check isolation level in mysql
SQL
0 vote128 views1 answer
Error: connect ECONNREFUSED 127.0.0.1:5432 at TCPConnectWrap.afterConnect [as oncomplete] (net.js:1148:16
SQL
8 votes139 views1 answer
Mysql restore database
SQL
0 vote156 views1 answer
Insert output identity
SQL
2 votes120 views1 answer
Get first 3 letters name in sql
SQL
1 vote120 views1 answer
Duplicating a MySQL table with all the data Command
SQL
2 votes85 views4 answers
Mysql change database character set to utf8mb4
SQL
21 votes125 views3 answers
Search for column name in sql db when i don't know which table it is in
SQL
11 votes136 views2 answers
How to import mysql database command line
SQL