Oracle all_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 votes145 views1 answer
No data found oracle
SQL
0 vote141 views1 answer
Postgresql create table with boolean column
SQL
0 vote136 views1 answer
Lost connection to mysql
SQL
0 vote143 views1 answer
Mysql shell ERROR: Not connected.
SQL
0 vote200 views1 answer
Postgres dump sql insert
SQL
2 votes139 views2 answers
Mysql on duplicate key ignore
SQL
4 votes182 views1 answer
Mysql delete last row
SQL
4 votes128 views3 answers
Mysql varchar length
SQL
0 vote147 views1 answer
Sql decode
SQL
0 vote176 views1 answer
Drop domain postgresql
SQL