How to check the Oracle database version

You can easily check the which version of oracle database you are use. Execute this statement to find this.

SELECT * FROM V$VERSION

      *** This will give you detailed version number of the database components. 



              OR

SELECT version FROM V$INSTANCE

              OR

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

END;

              OR

select from PRODUCT_COMPONENT_VERSION;

       **** This will give you various components of the DB with their version.


--- cheers !!!