Monday, December 28, 2015

Oracle select all functions, procedures, packages

To select all functions, procedures, packages 
 
SELECT * FROM ALL_OBJECTS WHERE OBJECT_TYPE IN ('FUNCTION','PROCEDURE','PACKAGE')

No comments:

Post a Comment