Re: help - statment to list versions of tools and oracle database

From: Mark <markg_at_mymail.co.uk>
Date: 30 Apr 2002 00:57:04 -0700
Message-ID: <ddb31653.0204292357.43ab6795_at_posting.google.com>

You could look at the V$VERSION view for a start, it will tell you version numbers of some of the server side tools. Client side tools? Probably have to do that manually by doing help - about.

SQL> select * from v$version;

BANNER

---

Oracle8 Enterprise Edition Release 8.0.6.0.0 - Production PL/SQL Release 8.0.6.0.0 - Production
CORE Version 4.0.6.0.0 - Production
TNS for IBM/AIX RISC System/6000: Version 8.0.6.0.0 - Production NLSRTL Version 3.3.3.0.0 - Production

Mark

skommar21_at_yahoo.com (Sridhar Reddy) wrote in message news:<63b88d7a.0204291455.1e42d7e7_at_posting.google.com>...
> hi,
> i need a select statment which would list the versions of various
> tools and database of oracle.
> with regards
> thank you
>
> sridhar
Received on Tue Apr 30 2002 - 09:57:04 CEST