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 vote312 views1 answer
How to use select union and loop
SQL
0 vote190 views1 answer
Mysql join table with a text columns with ids splited by char
SQL
0 vote168 views1 answer
Mysql_error replacement
SQL
3 votes167 views1 answer
Oracle sleep
SQL
31 votes194 views2 answers
Grant all priviledges to mysql user
SQL
0 vote156 views1 answer
Sql right characters
SQL
0 vote182 views1 answer
Buscar nombre de columna en todas las tablas sql server
SQL
0 vote179 views1 answer
Big table in mysql
SQL
3 votes183 views2 answers
Having in mysql
SQL
0 vote164 views1 answer
Trigger value from maltiple table to single table mysql
SQL