Re: Database Version

From: HansF <News.Hans_at_telus.net>
Date: Mon, 22 Aug 2005 22:23:09 GMT
Message-Id: <pan.2005.08.22.22.27.16.90638@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.

-- 
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 - 17:23:09 CDT