Re: Oracle version

gigione wrote:

> Hello everybody.
> Is there an SQL command telling me if there is installed Standard or
> Enterprise version of Oracle 9.2 installed on a windows 2000 server?
>
> If there isn't, how can I know it? Where must I look for?
> I found the key ORACLE_BUNDLE_NAME in the registry, but I don't know if
> this is correct.
>
> thank's a lot.
>
> Sam.

In addition to Howard's suggestion this is a good query to keep around.

SELECT comp_name, status, substr(version,1,10) AS version FROM dba_registry;

-- 
Daniel Morgan
http://www.outreach.washington.edu/ext/certificates/oad/oad_crs.asp
http://www.outreach.washington.edu/ext/certificates/aoa/aoa_crs.asp
damorgan_at_x.washington.edu
(replace 'x' with a 'u' to reply)