Oracle all_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 vote112 views1 answer
Sql developer export connections
SQL
10 votes100 views1 answer
Oracle dependency
SQL
0 vote120 views1 answer
Storing RGBA in mysql db
SQL
0 vote127 views1 answer
How to get one year old query from plan cache
SQL
3 votes116 views1 answer
Sql server version query
SQL
0 vote134 views1 answer
Creating h2 database in relative directory eclopse
SQL
7 votes115 views2 answers
Phpmyadmin change password
SQL
2 votes77 views1 answer
Foreign key example in dbms
SQL
1 vote132 views1 answer
Check current sequence value postgres
SQL
-1 vote110 views1 answer
How to switch user in mysql
SQL