Oracle dependency

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

4 votes307 views3 answers
Mysql get column names from table
SQL
0 vote288 views2 answers
Mysql two column combination unique
SQL
5 votes311 views1 answer
Mysql count lines
SQL
3 votes250 views2 answers
Mysql add 2 hours
SQL
0 vote283 views1 answer
MySQL INSERT IGNORE Statement
SQL
1 vote257 views2 answers
End mysql command
SQL
0 vote274 views1 answer
What is the difference between the LIKE and REGEXP operators in mysql?
SQL
0 vote255 views1 answer
Mysql workbench procedure
SQL
1 vote283 views1 answer
Date in where on datetime column clause mysql
SQL
4 votes288 views2 answers
Oracle drop job
SQL