Answers for "how to check if procedure is available in oracle"

SQL
0

plsql find location of procedure

SELECT * 
FROM SYS.DBA_DEPENDENCIES 
WHERE  REFERENCED_NAME = '<NAME_OF_PKG_OR_PROC_FUNC>' AND 
REFERENCED_TYPE IN ('PACKAGE', 'PROCEDURE', 'FUNCTION');
Posted by: Guest on July-02-2020

Code answers related to "how to check if procedure is available in oracle"

Code answers related to "SQL"

Browse Popular Code Answers by Language