-- 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';| Code Example |
|---|
| Sql :: query to find object dependencies in oracle |
| Sql :: mysql if |
| Sql :: oracle insert into where |
| Sql :: mysql find duplicates |
| Sql :: sql with example |
| Sql :: view table mysql |
| Sql :: mysql select date from datetime |
| Sql :: open postgresql.conf |
| Sql :: datepart sql server |
| Sql :: pl sql |
| Sql :: mysql case |
| Sql :: using minus query in SQL |
| Sql :: mysql loop |
| Sql :: ON DUPLICATE KEY UPDATE for postgres |
| Sql :: SQL COUNT() with WHERE |
| Sql :: sql select if not exists |
| Sql :: mysql where length greater than |
| Sql :: how to get previous year from sysdate in oracle |
| Sql :: mysql with |
| Sql :: postgressum when |
| Sql :: mysql query where in |
| Sql :: sql server today minus n |
| Sql :: sql select all records from all tables where not empty |
| Sql :: select value from previous row in postgresql |
| Sql :: oracle error line |
| Sql :: sql create table |
| Sql :: postgres find missing indexes |
| Sql :: declare temp table in sql |
| Sql :: mysql:5.6 syntax create table |
| Sql :: create db table |