Answers for "oracle list all stored procedures"

SQL
5

oracle list procedures

-- Depending on connected user grants:
SELECT * FROM USER_OBJECTS WHERE OBJECT_TYPE IN ('FUNCTION','PROCEDURE','PACKAGE');
SELECT * FROM ALL_OBJECTS WHERE OBJECT_TYPE IN ('FUNCTION','PROCEDURE','PACKAGE');
SELECT * FROM DBA_OBJECTS WHERE OBJECT_TYPE IN ('FUNCTION','PROCEDURE','PACKAGE');
Posted by: Guest on June-08-2021

Code answers related to "oracle list all stored procedures"

Code answers related to "SQL"

Browse Popular Code Answers by Language