Re: Detect Oracle Version Number

From: Mark D Powell <mark.powell_at_eds.com>
Date: 7 Dec 2001 06:00:21 -0800
Message-ID: <178d2795.0112070600.228df1b4@posting.google.com>

Ron Reidy <rereidy_at_indra.com> wrote in message news:<3C0FE585.137168D0_at_indra.com>...
> Look at the V$INSTANCE view.

You can also look at v$version

UT1> select * from v$version;

BANNER

---

Oracle8i Enterprise Edition Release 8.1.7.2.0 - 64bit Production PL/SQL Release 8.1.7.2.0 - Production
CORE 8.1.7.0.0 Production
TNS for IBM/AIX RISC System/6000: Version 8.1.7.2.0 - Production NLSRTL Version 3.4.1.0.0 - Production

• Mark D Powell --

Received on Fri Dec 07 2001 - 08:00:21 CST