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';

Source: grepper.com

Similar codes

1 vote120 views1 answer
Varchar plsql
SQL
1 vote122 views1 answer
Oracle drop job if exists
SQL
0 vote74 views1 answer
Grant owner postgresql
SQL
0 vote120 views1 answer
Postgresql on conflict pair
SQL
0 vote124 views1 answer
Varchar2 length in oracle
SQL
10 votes124 views2 answers
Doublon sql
SQL
0 vote122 views1 answer
Import excel to sql
SQL
0 vote122 views1 answer
Exec procedure oracle
SQL
1 vote69 views1 answer
Python escape string for sql
SQL
0 vote122 views1 answer
Query string starts with vowels
SQL