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

0 vote153 views1 answer
Load data from text file to mysql database on mac terminal
SQL
6 votes138 views1 answer
Wordpress change user password sql
SQL
8 votes148 views2 answers
Mysql grant all privileges to user from any host
SQL
0 vote158 views2 answers
Dumping sql table
SQL
0 vote151 views1 answer
Flush user resource mysql
SQL
8 votes145 views1 answer
Oracle find text in functions
SQL
0 vote172 views1 answer
Permission denied postgres \copy csv command line
SQL
1 vote157 views3 answers
How to reset id column in sql server
SQL
0 vote165 views1 answer
How to close external sql connection in laravel
SQL
0 vote146 views1 answer
Compare subqueries oracle
SQL