How to check the Oracle database version? Options

codeling 1217 - 5163
@2017-03-13 09:06:28

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