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

1 vote125 views1 answer
How much every mysql database record takes from diskspace
SQL
6 votes134 views2 answers
Foreign key sqlite3 python
SQL
0 vote127 views1 answer
What is ssrs and ssis in sql server
SQL
3 votes154 views5 answers
Duplicate table sql
SQL
0 vote129 views1 answer
Can't connect to postgresql mac os
SQL
4 votes137 views2 answers
Oracle sql group by date year
SQL
0 vote100 views1 answer
Ms sql unique
SQL
0 vote150 views1 answer
What is server_default = func.now() in sqlalchemy
SQL
0 vote122 views1 answer
Check connections to database postgres
SQL
-1 vote116 views3 answers
Mysql get age from date
SQL