Enterprise Edition or Standard Edition

Hi Guys
We used to have Oracle 8.1.7.0 Standard Edition. We just upgrade to 8.1.7.4.
What script will show me the type of version we have, stating not only the "8.1.7.4 but Enterprise edition
or Standard edition.

I query v$version.
select * from v$version;
it did not give me the info I really want.
Select * form v$license; not satisfy with the result.

I need the query to return the word"Enterprise Edition or Standard Edition"
Thanks

Don't know what you really mean by v$version..
This one works just fine here...

Code:

---


[email protected]L> select * from v$version
  2  /

BANNER
----------------------------------------------------------------
Oracle8i Enterprise Edition Release 8.1.7.4.1 - Production
PL/SQL Release 8.1.7.4.0 - Production
CORE    8.1.7.2.1      Production
TNS for 32-bit Windows: Version 8.1.7.4.0 - Production
NLSRTL Version 3.4.1.0.0 - Production

---

or maybe you can try this sql:

• select decode(instr(banner, 'Enterprise'), 0, 'Standard Edition', 'Enterprise Edition') from v$version where banner like '%Oracle%'
  /

This is what my result show on the production.
SQL> select * from v$version;

BANNER
--------------------
Oracle8i Release 8.1.7.4.1 - Production
PL/SQL Release 8.1.7.4.0 - Production
CORE 8.1.7.2.1 Production
TNS for 32-bit Windows: Version 8.1.7.4.0 - Production
NLSRTL Version 3.4.1.0.0 - Production

No mention of Enterprise or Standard.

Why don't you simply start OUI and see what it says?

Thanks Patel_Dil
Your script is just what I wanted.
Again Thanks

Can you pl. run the following query and let me know of the output

Code:

---


            SELECT * FROM product_component_version
            WHERE product LIKE '%Oracle%';

---

-Sam

Quote:

---

Originally posted by sambavan
Can you pl. run the following query and let me know of the output

Code:

---


            SELECT * FROM product_component_version
            WHERE product LIKE '%Oracle%';

---

-Sam

---

Sam,
V$PRODUCT_COMPONENT_VERSION is derived from V$VERSION so it won't show anything different.
Extract from catalog.sql

Code:

---

create or replace view product_component_version(product,version,status) as
(select
substr(banner,1, instr(banner,'Version')-1),
substr(banner, instr(banner,'Version')+8,
instr(banner,' - ')-(instr(banner,'Version')+8)),
substr(banner,instr(banner,' - ')+3)
from v$version
where instr(banner,'Version') > 0
and
((instr(banner,'Version') <  instr(banner,'Release')) or
instr(banner,'Release') = 0))
union
(select
substr(banner,1, instr(banner,'Release')-1),
substr(banner, instr(banner,'Release')+8,
instr(banner,' - ')-(instr(banner,'Release')+8)),
substr(banner,instr(banner,' - ')+3)
from v$version
where instr(banner,'Release') > 0
and
instr(banner,'Release') <  instr(banner,' - '))

---