Re: get version number with SQL query?

"Daniel Morgan" <damorgan_at_exxesolutions.com> wrote in message news:3F536186.B9CB23E0_at_exxesolutions.com...
> 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)
>
>

This is what I receive as sysdba:

SQL*Plus: Release 9.2.0.4.0 - Production on Man Sep 1 21:14:18

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

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

SQL> select comp_name, version from dba_registry;

Oracle9i Catalog Views 9.2.0.4.0
Oracle9i Packages and Types 9.2.0.4.0
Oracle Workspace Manager 9.2.0.1.0
JServer JAVA Virtual Machine 9.2.0.4.0
Oracle XDK for Java 9.2.0.6.0
Oracle9i Java Packages 9.2.0.4.0
Oracle interMedia 9.2.0.4.0
Spatial 9.2.0.4.0
Oracle Text 9.2.0.4.0
Oracle XML Database 9.2.0.4.0
Oracle Ultra Search 9.2.0.4.0
Oracle Data Mining 9.2.0.4.0
OLAP Analytic Workspace 9.2.0.4.0
Oracle OLAP API 9.2.0.4.0
OLAP Catalog 9.2.0.4.0

15 rows selected. Received on Mon Sep 01 2003 - 14:33:13 CDT