Enterprise Edition or Standard Edition

[SANJAY_G]

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

            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

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,' - '))