Re: What Versions are Installed

From: george lewycky <gelewyc_at_nyct.com>
Date: 18 Jun 2004 08:37:58 -0700
Message-ID: <68aecc05.0406180737.770ce959@posting.google.com>

I have a collection of tips, code and links on my site below and I have what you needed.

Try this:

SQL> select * from product_component_version;

PRODUCT

---

VERSION

---

STATUS

---

NLSRTL
3.4.1.0.0
Production

Oracle8i Enterprise Edition
8.1.7.3.0
Production

PL/SQL
8.1.7.3.0
Production

TNS for 32-bit Windows:
8.1.7.3.0
Production

George Lewycky
http://georgenet.net/oracle

aniel Morgan <damorgan_at_x.washington.edu> wrote in message news:<1087418359.25617_at_yasure>...
> spelegan_at_csc.com wrote:
>
> >
> > Is there some SQL script or some app. I can run that will tell me what
> > Oracle components I have installed and which version of these components
> > are installed. I'd also like to do this from the command line. Thanks.
>
> select banner from v$version;
>
> and/or
>
> select * from v$option;
>
> and/or
>
> SELECT comp_name, status, substr(version,1,10) as version
> FROM dba_registry;
>
> Perhaps.
Received on Fri Jun 18 2004 - 10:37:58 CDT