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

0 vote286 views1 answer
How to pass list as parameter in SQL query
SQL
0 vote256 views1 answer
How to see password mysql vestacp
SQL
1 vote249 views1 answer
Sql server find tables referenced foreign key
SQL
1 vote215 views1 answer
Strict in postgres SQL
SQL
0 vote209 views1 answer
Mysql select top 2
SQL
1 vote272 views4 answers
Get week day from date in sql
SQL
0 vote268 views1 answer
Creating a simple notify in postgresql
SQL
0 vote273 views1 answer
How to delete duplicate rows in oracle
SQL
3 votes264 views2 answers
How to list columns for particular tables in postgresql
SQL
1 vote246 views1 answer
Add sequence postgres
SQL