Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.misc -> Re: Database Version
"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