Re: Database Version

From: Turkbear <john.g_at_dot.spamfree.com>
Date: Mon, 22 Aug 2005 16:10:25 -0500
Message-ID: <9lfkg1tcu7mqs3iupla4l0b3bchh704oe0@4ax.com>

HansF <News.Hans_at_telus.net> wrote:

>On Mon, 22 Aug 2005 12:51:40 -0700, Sameer Deshpande interested us by
>writing:
>
>> I do not want to query v$version, because v$version gives me detailed
>> info. I just need a short description of db version like 9.2.0.4
>>
>
>select version from PRODUCT_COMPONENT_VERSION where product like
>'%Database%';
>
>as described in the "Oracle9i Database Reference Release 2 (9.2)" manual
>at http://docs.oracle.com and tested against Oracle Database 10g

Well maybe..

On our system we have:
SQL> select product,version from product_component_version;

PRODUCT                             VERSION
----------------------------------- ------------------
NLSRTL                              9.2.0.2.0
Oracle9i Enterprise Edition         9.2.0.2.1
PL/SQL                              9.2.0.2.1
TNS for 32-bit Windows:             9.2.0.2.0

No Product containing 'Database' is listed... Received on Mon Aug 22 2005 - 16:10:25 CDT