How to check the Oracle database version ?

10:55:00 0 Comments A+ a-

You can know the Oracle Database version by the following way :

login to sqlplus by  SYSTEM user OR SYSDBA.

Then Type one of the following command:



1- SELECT * FROM V$VERSION
or
2- SELECT version FROM V$INSTANCE
or
3- BEGIN DBMS_OUTPUT.PUT_LINE(DBMS_DB_VERSION.VERSION || '.' || DBMS_DB_VERSION.RELEASE); END;