Oracle object dependencies

-- 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

5 votes175 views2 answers
Oracle find all tables with column name
SQL
13 votes189 views3 answers
Change data type postgresql
SQL
2 votes180 views1 answer
Orcale index size
SQL
2 votes176 views3 answers
Current month mysql query
SQL
1 vote176 views1 answer
Change old domain to new domain name wordpress
SQL
0 vote180 views1 answer
Custom row number
SQL
2 votes180 views1 answer
SQL IF ELSE
SQL
0 vote168 views1 answer
Mysql date time string format python
SQL
1 vote181 views1 answer
ORACLE RIGHT TWO DIGITS
SQL
0 vote174 views1 answer
Mariadb number format
SQL