Oracle view 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';

Source: grepper.com

Similar codes

0 vote205 views1 answer
Get date from timestamp in mysql
SQL
0 vote246 views2 answers
How to install psql in ubuntu
SQL
0 vote232 views1 answer
Remove mysql from centos 7
SQL
4 votes201 views1 answer
Mysql not equal
SQL
0 vote202 views1 answer
How to connect sqlalchemy to mysql and deploy it
SQL
0 vote150 views1 answer
How to get last client id sql
SQL
0 vote194 views1 answer
Mysql query to add hours to column in table
SQL
17 votes192 views4 answers
Sort by mysql
SQL
7 votes205 views3 answers
Foreign key oracle
SQL
0 vote198 views2 answers
Null value in column violates not-null constraint
SQL