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 vote315 views1 answer
How to find total working hour in sql
SQL
0 vote303 views1 answer
Transaction database with php
SQL
0 vote306 views1 answer
Sql alter table add column if exists
SQL
4 votes297 views2 answers
Postgres update single column
SQL
0 vote311 views1 answer
Default column value in sql same as another column laravel
SQL
23 votes290 views3 answers
Mysqldump
SQL
0 vote249 views1 answer
Count char in java
SQL
6 votes298 views2 answers
Database url postgres
SQL
9 votes309 views1 answer
No sql
SQL
0 vote305 views1 answer
Column ' ' in field list is ambiguous
SQL