Oracle dependencies table

-- 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 vote129 views1 answer
Postgresql create table with boolean column
SQL
2 votes142 views1 answer
Mysql change data type of column
SQL
7 votes126 views6 answers
Group_concat mysql
SQL
0 vote133 views1 answer
Mariadb errno 121
SQL
3 votes147 views1 answer
Increment integer in table sql
SQL
0 vote125 views1 answer
How to count null values in sql
SQL
2 votes176 views1 answer
Creating a view SQL
SQL
2 votes120 views1 answer
SQL IF ELSE
SQL
16 votes153 views1 answer
Sql comment'
SQL
0 vote138 views1 answer
How to print records of employees hired in particular month in oracle
SQL