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

0 vote138 views1 answer
Renommer table sql
SQL
0 vote140 views1 answer
How to start my sql server on mac
SQL
5 votes143 views1 answer
Sql add column after another
SQL
0 vote132 views1 answer
Complete date is 1 year or not sql server
SQL
0 vote135 views1 answer
Max length found in mysql
SQL
0 vote144 views1 answer
Supprimer les valeur d'une table mysql
SQL
0 vote135 views1 answer
Sql gather statistics to increase performance
SQL
2 votes146 views1 answer
Mysql ALTER TABLE ADD COLUMN BOOLEAN AFTER DEFAULT "1";
SQL
0 vote140 views1 answer
Oracle SQL join three tables and group by column
SQL
2 votes180 views2 answers
Mysql search for column name in all tables
SQL