Oracle Version info ... how to read it !!!!

read oracle version
Oracle Release Numbers
Oracle Version No Info
Release Number Format
Release No


Oracle database server labeled "Release 10.2.0.1.0" The significance of each number



10 :- Major database release number
2 :- Database maintenance release number
0 :- Application server release number
1 :- Component specific release number
0 :- Platform specific release number







Version Number : This is the most general identifier. It represents a major new edition (or version) of
the software and contains significant new functionality.

New Features Release Number : This number represents a new features release level.

Maintenance Release Number : This number represents a maintenance release level. A few new features may also be included.

Generic Patch Set Number : This number identifies a generic patch set. The patch set is applicable across all operating
system and hardware platforms.








COL PRODUCT FORMAT A40
COL VERSION FORMAT A15
COL STATUS    FORMAT A15
SELECT * FROM PRODUCT_COMPONENT_VERSION;



set linesize 200
col banner for a100
select * from v$version ;


 select BANNER "Oracle Version...." from v$version ;


select version from v$instance ;


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