Answers for "oracle packages"

SQL
5

oracle list packages

-- 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 "SQL"

Browse Popular Code Answers by Language