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: HansF <News.Hans_at_telus.net>
Date: Mon, 22 Aug 2005 20:43:48 GMT
Message-Id: <pan.2005.08.22.20.47.55.211295@telus.net>


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

Original text of this message

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