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

3 votes196 views1 answer
Postgres select max value
SQL
4 votes204 views2 answers
Tables in sql
SQL
0 vote232 views1 answer
Postgresql select fast check no rows
SQL
2 votes183 views1 answer
Mysql ALTER TABLE ADD COLUMN BOOLEAN AFTER DEFAULT "1";
SQL
0 vote172 views1 answer
Sqlite3 now
SQL
0 vote255 views3 answers
How to find all role in mysql
SQL
0 vote211 views1 answer
Data types mysql vs postgresql
SQL
0 vote180 views1 answer
Longtext sql
SQL
0 vote153 views1 answer
Sqlalchemy existing database
SQL
0 vote192 views1 answer
Display first three characters sql
SQL