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

2 votes119 views1 answer
How to make insert script from table in SQL server
SQL
0 vote126 views1 answer
Sql quary intervewi question
SQL
1 vote118 views1 answer
Org.h2.jdbc.jdbcsqlsyntaxerrorexception
SQL
0 vote129 views1 answer
Increase speed of like queries postgres
SQL
1 vote110 views2 answers
Sqlalchemy.exc.OperationalError: (sqlite3.OperationalError) unable to open database file
SQL
8 votes122 views1 answer
How to remove tables from postgresql
SQL
3 votes109 views1 answer
Two selects in one query
SQL
6 votes122 views1 answer
Postgres get size of database
SQL
0 vote122 views1 answer
Services.AddDbContext DataSource Sqlite
SQL
0 vote120 views1 answer
Hashpass
SQL