Oracle view 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 vote131 views1 answer
Connecting mySQL to STS
SQL
0 vote107 views1 answer
Adding conditions in MERGE statement in Oracle SQL for INSERT/UPDATE
SQL
0 vote97 views1 answer
Dnsmasq.conf location macos
SQL
11 votes112 views1 answer
How to get ddl for materialized view
SQL
4 votes120 views1 answer
Adding data to table in sql python
SQL
0 vote75 views1 answer
Query for maximum salary
SQL
0 vote111 views1 answer
Parent: [Error: SQLITE_READONLY: attempt to write a readonly database] {
SQL
0 vote111 views2 answers
Plan d'exécution requete oracle autotracer
SQL
0 vote104 views2 answers
Update all linkedserver tables with openquery on db
SQL
0 vote117 views1 answer
Sql server sleep
SQL