How to find out oracle is enterprise edition or standard edition?

[Gurumurthy Ramamurthy]

Hi,

Is there any way through java program to find out that whether the installed oracle is enterprise edition or standard edition?
I have only the hostname, portnumber, SID, username, password available with me.

I was trying to connect to the database and through any SQL commands to find out EE or SE?

Thanks,
Guru

[Jeanne Boyarsky]

I haven't tried it but this site has a promising query:

select * from v$version where banner like 'Oracle%';

[Martin Vajsar]

In your other question (which is locked now) you asked how to test whether partitioning is installed; it can be queries from the v$option view:select * from v$option where parameter='Partitioning'; There are more editions than just EE and SE. If you are interested in a specific option, this is probably better way to test it.