OraFAQ Forum: Server Administration » View version of Oracle database via SQL?

Home » RDBMS Server » Server Administration » View version of Oracle database via SQL?

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

View version of Oracle database via SQL? [message #140253]

Mon, 03 October 2005 04:19

NewEra
Messages: 3
Registered: October 2005

Junior Member

Is there an SQL to view the version information of a database?

Report message to a moderator

Re: View version of Oracle database via SQL? [message #140254 is a reply to message #140253]

Mon, 03 October 2005 04:26

tarundua
Messages: 1080
Registered: June 2005
Location: India

Senior Member


SQL> select version from v$instance;

VERSION
-----------------
9.2.0.1.0

regards,
tarun

Report message to a moderator

Re: View version of Oracle database via SQL? [message #140257 is a reply to message #140254]

Mon, 03 October 2005 04:46

girish.rohini
Messages: 744
Registered: April 2005
Location: Delhi (India)

Senior Member

The below eg. clarifies:

$ sqlplus conn_string
--Client Info:
SQL*Plus: Release 9.2.0.4.0 - Production on Mon Oct 3 05:44:13 2005

Copyright (c) 1982, 2002, Oracle Corporation. All rights reserved.

--Server info:
Connected to:
Oracle9i Enterprise Edition Release 9.2.0.4.0 - Production
With the Partitioning, OLAP and Oracle Data Mining options
JServer Release 9.2.0.4.0 - Production

SQL>

---Girish

Report message to a moderator

Previous Topic:	ORA-1555 Error
Next Topic:	ARCn and PMON!!

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Wed Sep 10 20:09:16 CDT 2025