Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.misc -> Re: Database Version

Re: Database Version

From: Randy Harris <randy_at_SpamFree.com>
Date: Tue, 23 Aug 2005 00:54:06 GMT
Message-ID: <OsuOe.696$yo7.192@newssvr23.news.prodigy.net>

"HansF" <News.Hans_at_telus.net> wrote in message news:pan.2005.08.22.22.27.16.90638_at_telus.net...
> On Mon, 22 Aug 2005 21:23:00 +0000, HansF interested us by writing:
>
> Looking at the catalog.sql for the desc of product_component_version is
> very informative. It's derived entirely from the single column v$version.
>
> However, possibly a better solution for OP is to
>
> select version from v$instance;
>
> which is true in both 9i and 10g.

Works in 8i as well. Received on Mon Aug 22 2005 - 19:54:06 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US