Oracle object 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 vote103 views1 answer
Sql runnignsum
SQL
0 vote144 views1 answer
Alter column to not null with default value sql server
SQL
0 vote153 views1 answer
Postgresql port 5432 not open
SQL
0 vote293 views1 answer
Current month transactions in mysql
SQL
5 votes117 views2 answers
Oracle list columns schema
SQL
0 vote127 views1 answer
Backup a table in sql
SQL
8 votes147 views1 answer
Show mysql user table
SQL
0 vote133 views1 answer
Cartesian product sql
SQL
1 vote148 views1 answer
Get parameter value in mysql trigger
SQL
25 votes141 views3 answers
Mysql command show tables
SQL