find version number of oracle [message #333272] |
Fri, 11 July 2008 01:44  |
sarwagya
Messages: 87 Registered: February 2008 Location: Republic of Nepal
|
Member |
|
|
Hi!
I need to find out the version of my oracle database through select query.
So, I used
SELECT REGEXP_SUBSTR(banner,'[url=/wiki/:digit:]:digit:[/url]+.[url=/wiki/:digit:]:digit:[/url]') version
FROM v$version
WHERE ROWNUM = 1;
But, my problem is that the regexp_substr works only in 10g and above.
so, is there any other way to find the version (number only)through select query.
please suggest.
Thank you.
Sarwagya.
|
|
|
|
Re: find version number of oracle [message #333279 is a reply to message #333272] |
Fri, 11 July 2008 02:24   |
S.Rajaram
Messages: 1027 Registered: October 2006 Location: United Kingdom
|
Senior Member |
|
|
SQL> l
1* select * from product_component_version
SQL> /
PRODUCT VERSION STATUS
-------------------------------------------------- ------------------------------ ------------------------------
NLSRTL 11.1.0.6.0 Production
Oracle Database 11g Enterprise Edition 11.1.0.6.0 64bit Production
PL/SQL 11.1.0.6.0 Production
TNS for Linux: 11.1.0.6.0 Production
SQL> select * from v$version;
BANNER
--------------------------------------------------------------------------------
Oracle Database 11g Enterprise Edition Release 11.1.0.6.0 - 64bit Production
PL/SQL Release 11.1.0.6.0 - Production
CORE 11.1.0.6.0 Production
TNS for Linux: Version 11.1.0.6.0 - Production
NLSRTL Version 11.1.0.6.0 - Production
Regards
Raj
|
|
|
|
Re: find version number of oracle [message #333304 is a reply to message #333272] |
Fri, 11 July 2008 03:38  |
sarwagya
Messages: 87 Registered: February 2008 Location: Republic of Nepal
|
Member |
|
|
Thanks everybody.
I decided to use product_component_version to solve my problem.
@ttparavindh
I think u didn't get my problem properly. I wanted the numeric part of the oracle version.
Thanks again everybody.
|
|
|