H.Tonguç YILMAZ Blog

1st Digit: “10” is a major database release number.

2nd Digit: “2” is the database maintenance release number.

3rd Digit: “0” is the application server release number.

4th Digit: “2” identifies a release level specific to a component.

5th Digit: “0” identifies a platform specific release.

To check the Oracle version from the SQL*Plus prompt, issue following sql:

SELECT banner
FROM v$version
WHERE banner LIKE ‘Oracle%’;

BANNER
—————————————————————-
Oracle Database 10g Enterprise Edition Release 10.2.0.2.0 - 64bi

SELECT version
FROM product_component_version
WHERE product LIKE ‘Oracle%’;

VERSION
—————————————————————-
10.2.0.2.0

Reference
http://blog.oraclebrains.com/?p=29