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

0 vote279 views1 answer
Convert .mdf to .bak
SQL
3 votes265 views3 answers
Stop mysql service ubuntu
SQL
1 vote267 views2 answers
Sqlalchemy.exc.OperationalError: (sqlite3.OperationalError) unable to open database file
SQL
0 vote301 views1 answer
Sqlite3_open_v2
SQL
0 vote263 views1 answer
MySql count occurences more than"
SQL
0 vote261 views1 answer
How to count with except in psql
SQL
0 vote280 views1 answer
Fetcht he leftmost word in a comma separated string in sql
SQL
0 vote273 views1 answer
Convert rows into columns in oracle
SQL
0 vote276 views1 answer
Recover deleted data from mysql database
SQL
4 votes279 views3 answers
Drop Table Oracle
SQL