query to find object dependencies in oracle

Solutions on MaxInterview for query to find object dependencies in oracle by the best coders in the world

Search
showing results for - "query to find object dependencies in oracle"
Andrea
20 Jun 2020
1-- Dependencies on a view, table, ...
2SELECT *
3  FROM ALL_DEPENDENCIES			-- or DBA_DEPENDENCIES or USER_DEPENDENCIES
4 WHERE TYPE = 'VIEW'			-- or 'PROCEDURE', 'SYNONYM'...
5   AND REFERENCED_OWNER = 'OBJECT_OWNER'
6   AND REFERENCED_NAME = 'OBJECT_NAME';
similar questions
oracle source queryoracle search view codehow to get list of synonyms in oraclemodule operator in oracle sqloracle find sql idoracle get view definitionoracle get current schemaoracle selectoracle show running queriesselect all source oracleoracle query to see what scema i am working inselect sequence oracleoracle vieworacle running queriesoracle get running querieshow to get the query of a view in oracleallsource oracleoracle list packagesoracle search code in packagesoracle search columns in schemaoracle query to find schema you are working onoracle search text in all packagesquery saurce oracle
queries leading to this page
oracle dba dependenciesuser dependenciesall dependencies examplehow can find oracle table dependenciesoracle object dependencies oracle dependencydba dependenciesobject dependencies in oracleoracle dependencies tabledependency table in oraclequery to find object dependencies in oracleall dependenciesdba dependencies dba objects editionable oracleoracle all dependenciesoracle view dependenciesobject dependencies oraclemaven oracle dependencydba dependencies dba objects edition oraclequery to find object dependencies in oracle