-
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
Arsene Lupain
The lie takes the elevator, the truth takes the staircase but ends up catching up with the lie.
-
Don't know what you really mean by v$version..
This one works just fine here...
Code:
scott@NICK817.TARRY.LOCAL> 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
Tarry Singh
I'm a JOLE(JavaOracleLinuxEnthusiast)
--- Everything was meant to be---
-
or maybe you can try this sql:
- select decode(instr(banner, 'Enterprise'), 0, 'Standard Edition', 'Enterprise Edition') from v$version where banner like '%Oracle%'
/
-- Dilip
-
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.
Arsene Lupain
The lie takes the elevator, the truth takes the staircase but ends up catching up with the lie.
-
Why don't you simply start OUI and see what it says?
-
Thanks Patel_Dil
Your script is just what I wanted.
Again Thanks
Arsene Lupain
The lie takes the elevator, the truth takes the staircase but ends up catching up with the lie.
-
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
Thanx
Sam
Life is a journey, not a destination!
-
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,' - '))
Sanjay G.
Oracle Certified Professional 8i, 9i.
"The degree of normality in a database is inversely proportional to that of its DBA"
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|