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

Similar codes

0 vote226 views2 answers
Uninstall postgresql mac
SQL
0 vote215 views1 answer
Mysql date minus 1 day
SQL
1 vote212 views1 answer
Postgres regex remove special characters
SQL
2 votes220 views2 answers
Created at and updated at in mysql
SQL
5 votes207 views1 answer
Oracle ora-00054 causes
SQL
22 votes223 views4 answers
Mysql date format
SQL
0 vote218 views1 answer
Raven ql select count
SQL
0 vote240 views1 answer
Postgresql print sessions using the database
SQL
0 vote206 views1 answer
Oracle get running queries
SQL
-1 vote241 views2 answers
Installing mysql on centos 7
SQL