Re: get version number with SQL query?

Niall Litchfield wrote:

> "vipan" <dba_at_no_spam.netscape.net> wrote in message
> news:3F5332C0.6090001_at_no_spam.netscape.net...
> > Hi
> >
> > you can query DBA_REGISTRY view and get the version of installed
> components.
>
> Not on any of my 8i databases you can't.
>
> --
> Niall Litchfield
> Oracle DBA
> Audit Commission UK

Not with 9i either as clearly shown by the following.

In fact the following is what is produced:

SQL*Plus: Release 9.2.0.2.0 - Production on Mon Sep 1 08:08:14 2003

Copyright (c) 1982, 2002, Oracle Corporation. All rights reserved.

Connected to:
Oracle9i Enterprise Edition Release 9.2.0.2.1 - Production With the Partitioning, OLAP and Oracle Data Mining options JServer Release 9.2.0.2.0 - Production

SQL> desc dba_registry

 Name                                      Null?    Type
 ----------------------------------------- -------- ---------------
 COMP_ID                                   NOT NULL VARCHAR2(30)
 COMP_NAME                                          VARCHAR2(255)
 VERSION                                            VARCHAR2(30)
 STATUS                                             VARCHAR2(11)
 MODIFIED                                           VARCHAR2(20)
 CONTROL                                   NOT NULL VARCHAR2(30)
 SCHEMA                                    NOT NULL VARCHAR2(30)
 PROCEDURE                                          VARCHAR2(61)
 STARTUP                                            VARCHAR2(8)
 PARENT_ID                                          VARCHAR2(30)

SQL> select version from dba_registry;

VERSION

9.2.0.1.0
9.2.0.1.0
9.2.0.1.0

SQL>

dba_registry shows 9.2.0.1.0 and the fact, as indicating at login is clearly different.

--
Daniel Morgan
http://www.outreach.washington.edu/extinfo/certprog/oad/oad_crs.asp
http://www.outreach.washington.edu/extinfo/certprog/aoa/aoa_main.asp
damorgan_at_x.washington.edu
(replace 'x' with a 'u' to reply)