While wandering in the web jungle I came across this note, which I decided to put online as I think it is sort of important info which every person working with Oracle technology should know and will be interested to know.
What exactly the significant of digit is in bold in each release?
Release 10.2.0.2.0
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%’;
Or
SELECT version
FROM product_component_version
WHERE product LIKE ‘Oracle%’;
3 responses so far ↓
1 H.Tonguç YILMAZ Blog » What does “Release 10.2.0.2.0″ mean? // Dec 6, 2006 at 2:15 pm
[...] Reference http://blog.oraclebrains.com/?p=29 [...]
2 OracleBrains.Com » Blog Archive » Understanding Oracle Release Number Format - 3 // Dec 23, 2006 at 1:14 pm
[...] Understanding Oracle Release Number Format [...]
3 OracleBrains Oracle Community Webspace - Blog » Understanding Oracle Release Number Format - 3 // Dec 24, 2006 at 5:30 pm
[...] I collected some feedback about my earlier blog.First Blog LinkUnderstanding Oracle Release Number FormatSecond Blog LinkUnderstanding Oracle Release Number Format - 2 [...]
Leave a Comment