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

2 votes264 views3 answers
Postgres remove foreign key constraint
SQL
0 vote263 views3 answers
Above average salary in sql
SQL
5 votes285 views2 answers
Get number of columns sql
SQL
0 vote286 views1 answer
Shortcut run sql pgadmin
SQL
0 vote277 views1 answer
Can't connect to postgresql mac os
SQL
0 vote283 views1 answer
Oracle change password expiration policy
SQL
0 vote266 views2 answers
Postgresql get last day of month
SQL
2 votes279 views1 answer
Sql as
SQL
7 votes246 views1 answer
Mysql load data infile csv
SQL
0 vote285 views1 answer
Recently updated stored procedure in sql server
SQL