Oracle object 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

1 vote358 views2 answers
List tables sqlalchemy
SQL
11 votes384 views2 answers
How to import mysql database command line
SQL
0 vote354 views1 answer
How to insert multiple rows in mysql using laravel
SQL
28 votes378 views6 answers
Foreign key
SQL
18 votes345 views2 answers
Find all tables containing column with specified name - MS SQL Server
SQL
0 vote305 views1 answer
Kannst du deine finger trainieren
SQL
0 vote369 views1 answer
Mysql get last 2 month data
SQL
3 votes342 views4 answers
Mysql create table from select statement
SQL
0 vote365 views1 answer
Stored function in sql
SQL
52 votes609 views6 answers
Rename column sql
SQL