Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.misc -> Re: Database Version
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
-- Hans Forbrich Canada-wide Oracle training and consulting mailto: Fuzzy.GreyBeard_at_gmail.com *** I no longer assist with top-posted newsgroup queries ***Received on Mon Aug 22 2005 - 15:43:48 CDT