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

2 votes124 views1 answer
Oracle create directory
SQL
0 vote129 views1 answer
Mql5 list all available symbols
SQL
0 vote153 views1 answer
Running percentage of total postgres
SQL
3 votes130 views2 answers
Current year sql
SQL
0 vote127 views1 answer
SQL Server format datetime
SQL
1 vote153 views2 answers
Sql multiline comment
SQL
2 votes188 views1 answer
Oracle block
SQL
0 vote142 views1 answer
Less than date query sqlachemy
SQL
0 vote146 views1 answer
Drop column from local database postgres pgadmin
SQL
0 vote138 views1 answer
Get clob size oracle
SQL