How to check the Oracle database version? Options

codeling Posts: 1054 Points: 4431
Posted: Monday, March 13, 2017 9:06:28 AM

To get detailed version number of the database components, you can try:

SELECT * FROM V$VERSION

or

SELECT version FROM V$INSTANCE

or

BEGIN DBMS_OUTPUT.PUT_LINE(DBMS_DB_VERSION.VERSION || '.' || DBMS_DB_VERSION.RELEASE); END;

 

 
Users browsing this topic
Guest