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?
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:
WHERE banner LIKE ‘Oracle%’;
WHERE product LIKE ‘Oracle%’;