Home » SQL & PL/SQL » SQL & PL/SQL » find version number of oracle
find version number of oracle [message #333272] Fri, 11 July 2008 01:44 Go to next message
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 #333274 is a reply to message #333272] Fri, 11 July 2008 01:54 Go to previous messageGo to next message
ttparavindh
Messages: 22
Registered: December 2006
Location: Bangalore,India
Junior Member

Try with this below statement,

SELECT *
FROM V$VERSION;

Best regards.
Re: find version number of oracle [message #333279 is a reply to message #333272] Fri, 11 July 2008 02:24 Go to previous messageGo to next message
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 #333286 is a reply to message #333272] Fri, 11 July 2008 02:40 Go to previous messageGo to next message
Michel Cadot
Messages: 68737
Registered: March 2007
Location: Saint-Maur, France, https...
Senior Member
Account Moderator
DBMS_DB_VERSION
DBMS_UTILITY.DB_VERSION
require no privilege.

Regards
Michel
Re: find version number of oracle [message #333304 is a reply to message #333272] Fri, 11 July 2008 03:38 Go to previous message
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.
Previous Topic: comparing amounts
Next Topic: Table Determination
Goto Forum:
  


Current Time: Sat Feb 15 20:07:54 CST 2025