Oracle dependencies table

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

3 votes349 views3 answers
C# sql select
SQL
0 vote346 views1 answer
Having trouble running COUNT in my INSERT INTO statement
SQL
0 vote388 views1 answer
Sql sort ages
SQL
0 vote360 views1 answer
Join creating duplicate columns sqllite
SQL
0 vote366 views1 answer
Creating h2 database in relative directory eclopse
SQL
0 vote329 views1 answer
Wordpress sql change site url
SQL
0 vote372 views1 answer
Alter table change default
SQL
2 votes369 views4 answers
Check timezone of mysql database
SQL
11 votes336 views2 answers
Having clause
SQL
0 vote351 views1 answer
Drop CHECK constraint sql
SQL