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 vote185 views1 answer
Createdb with postgresql on ubuntu
SQL
7 votes183 views4 answers
Database dump mysql command
SQL
0 vote193 views1 answer
Transaction database with php
SQL
4 votes177 views1 answer
What are the data types in sql
SQL
10 votes191 views2 answers
Mysql alter add foreign key
SQL
0 vote175 views1 answer
Mysql select all where count more than"
SQL
1 vote185 views1 answer
How to select rows with no matching entry in another table?
SQL
1 vote173 views1 answer
Search for tables with name postgresql
SQL
0 vote179 views1 answer
Connect to ssms with python
SQL
3 votes189 views2 answers
Truncate all tables
SQL