Answers for "oracle all version list"

SQL
3

check oracle version

SELECT * FROM v$version;
Posted by: Guest on January-21-2021
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