Re: How to find out if Enterprise or Standard installed

On Mon, 17 Jun 2002 00:01:36 -0400, Craig Robinson wrote:

> Experts,
> If you came across an Oracle 8.1.7 install that you had never seen
> before, is there any easy way to determine if Oracle Enterprise or Oracle
> Standard is installed?
>
> Thanks for your help.
>
> Cheers, Craig Robinson
> (craig.robinson_at_epa.qld.gov.au)
 

select banner from v$version where lowerr(banner) like '%enterprise%';

-- 
Mladen Gogala
In God We Trust. 
All others must provide data.