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 vote348 views1 answer
Selecting Multiple Columns in SQL
SQL
3 votes327 views2 answers
Oracle apex charging debug
SQL
0 vote361 views1 answer
Netstat -tln mysql
SQL
0 vote316 views1 answer
Storing RGBA in mysql db
SQL
0 vote303 views1 answer
Show function mysql
SQL
1 vote337 views1 answer
Postgres power
SQL
0 vote343 views1 answer
Dump only data
SQL
1 vote321 views1 answer
How to get mysql db size
SQL
0 vote372 views1 answer
How to convert external table to managed table in hive
SQL
0 vote335 views1 answer
Insert overwrite table in mysql in nifi
SQL