OraFAQ Forum: SQL & PL/SQL » How to find version of the database

Home » SQL & PL/SQL » SQL & PL/SQL » How to find version of the database

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

How to find version of the database [message #10660]

Sun, 08 February 2004 20:36

S.Rajesh Kannan
Messages: 26
Registered: September 2003

Junior Member

How to find version of the oracle database through SQL Query?.

Thanks in advance.

S.Rajesh Kannan

Report message to a moderator

Re: How to find version of the database [message #10665 is a reply to message #10660]

Sun, 08 February 2004 23:44

Maaher
Messages: 7065
Registered: December 2001

Senior Member

Select Banner From v$version:

SQL> Select banner
  2    From v$version;

BANNER
----------------------------------------------------------------
Personal Oracle9i Release 9.2.0.4.0 - Production
PL/SQL Release 9.2.0.4.0 - Production
CORE    9.2.0.3.0       Production
TNS for 32-bit Windows: Version 9.2.0.4.0 - Production
NLSRTL Version 9.2.0.4.0 - Production

SQL>

MHE

Report message to a moderator

Re: How to find version of the database [message #10728 is a reply to message #10660]

Thu, 12 February 2004 08:56

William Robertson
Messages: 1643
Registered: August 2003
Location: London, UK

Senior Member

For variety you could also use DBMS_UTILITY.DB_VERSION:

SQL> var version varchar2(20)
SQL> var compatibility varchar2(20)
SQL> set autoprint on
SQL> exec DBMS_UTILITY.DB_VERSION(:version, :compatibility)

PL/SQL procedure successfully completed.

COMPATIBILITY
--------------------------------
9.2.0.0.0

VERSION
--------------------------------
9.2.0.4.0

SQL>

Report message to a moderator

Previous Topic:	OWA_UTIL.CALENDARPRINT
Next Topic:	Sql_loader question

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Wed Nov 05 03:20:00 CST 2025