Re: How to check Oracle Version by SQL select

From: John Alexander <jalexander_at_summitsoftwaredesign.com>
Date: Fri, 22 Dec 2000 00:51:51 GMT
Message-ID: <HAx06.87399$58.11398389@typhoon.tampabay.rr.com>

Depending on the format you want, query v$version or product_component_version:

SQL> select *
  2 from v$version
  3 /

BANNER

---

Oracle8i Enterprise Edition Release 8.1.6.0.0 - Production PL/SQL Release 8.1.6.0.0 - Production
CORE 8.1.6.0.0 Production
TNS for 32-bit Windows: Version 8.1.6.0.0 - Production NLSRTL Version 3.4.1.0.0 - Production

SQL> select *
  2 from PRODUCT_COMPONENT_VERSION
  3 /

PRODUCT

---

VERSION

---

STATUS

---

NLSRTL
3.4.1.0.0
Production

Oracle8i Enterprise Edition
8.1.6.0.0
Production

PL/SQL
8.1.6.0.0
Production

TNS for 32-bit Windows:
8.1.6.0.0
Production

John Alexander
www.SummitSoftwareDesign.com
St. Petersburg, FL

Kian Lee <ooiklnews_at_yahoo.com> wrote in message news:91u70p$423$1_at_nnrp1.deja.com...
> Hi all,
>
> How to I check the Oracle DB Version by issuing a simple SQL select
> statement?
>
> Thanks.
>
> Regards,
> Kian Lee
>
>
> Sent via Deja.com
> http://www.deja.com/
>
Received on Thu Dec 21 2000 - 18:51:51 CST