Oracle dependency

-- 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 vote163 views1 answer
Sql to excel pgadmin
SQL
3 votes141 views2 answers
How to delete git repo locally
SQL
0 vote155 views1 answer
Show all sequences postgres
SQL
0 vote142 views1 answer
Select into table variable
SQL
3 votes143 views2 answers
MySQL query to get column names
SQL
1 vote125 views1 answer
Media sql
SQL
0 vote139 views1 answer
How to connect sqlalchemy to mysql and deploy it
SQL
5 votes139 views1 answer
Sort order on two columns sql
SQL
0 vote175 views1 answer
AddEntityFrameworkSqlite
SQL
2 votes134 views1 answer
Mysql sysdate - 1 day
SQL