Re: How to distinguish whether a product is StandardEdition or an Enterprise Edition

Parse the banner.

Just be careful that if you are trying to do it across versions, the banners may be different. It may also be different based on the options installed.

If my memory serves me right it is the absence of the string "Enterprise Edition" that makes it a "Standard Edition".

//tc

"Subrahmanyam Arya" <avsrk_at_mailcity.com> wrote in message news:25c1993e.0304171244.17313bb7_at_posting.google.com...
> Hi gurus,
>
> IS there any other query which says the orcale product that is
> installed is Enterprise Edition or Standard Edition ???
>
> I know that select banner from V$VERSION; prints the info wich says
> whether it is enterprise or standard.
>
> I am looking to code in my application/shcema install script a
> function which checks if EE is installed then do something else if SE
> do some thing else
>
> If there is none, iwill parse the banner.
>
> -thx,
> avsrk
Received on Thu Apr 17 2003 - 23:01:44 CEST