Re: Oracle version

From: GC <johnny_sanga_at_hotmail.com>
Date: Mon, 27 Dec 1999 00:47:18 GMT
Message-ID: <3866B779.C53D5A0F@hotmail.com>

"news.earthlink.net" wrote:
>
> Hi,
> How to find which version of oracle server, enterprise manager,SQLpLus are
> installed on NT machine? if more than one version like oracle 7.x and 8.x,
> how to find that too?
>
> Thanks a lot.
>
> Rabi

To get the database version:

SVRMGR> select * from v$version;
BANNER

---

Oracle8i Enterprise Edition Release 8.1.5.0.1 - Production PL/SQL Release 8.1.5.0.0 - Production
CORE Version 8.1.3.0.0 - Production
TNS for Linux: Version 8.1.5.0.0 - Production NLSRTL Version 3.4.0.0.0 - Production

OEM should have a 'help' menu that will give the version number, and sqlplus will give the version number when you start it up:

%sqlplus

SQL*Plus: Release 8.1.5.0.0 - Production on Sun Dec 26 20:47:38 1999

(c) Copyright 1999 Oracle Corporation. All rights reserved.

Cheers,
GC Received on Sun Dec 26 1999 - 18:47:18 CST