Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Mailing Lists -> Oracle-L -> Re: Re : Which Oracle Edition am I running

Re: Re : Which Oracle Edition am I running

From: Gints Plivna <gints.plivna_at_gmail.com>
Date: Thu, 28 Jun 2007 16:33:11 +0300
Message-ID: <6e49b6d00706280633ud30a6e2la579b1cfde9366bb@mail.gmail.com>


OK don't know how it was for 8i but here are records for 10g SQL> conn ***/***@10enterprise
Connected.
SQL> select * from PRODUCT_COMPONENT_VERSION;

PRODUCT



VERSION

STATUS

NLSRTL
10.2.0.1.0
Production

Oracle Database 10g Enterprise Edition
10.2.0.1.0
Prod

PL/SQL
10.2.0.1.0
Production

TNS for 32-bit Windows:
10.2.0.1.0
Production

SQL> select * from v$version;

BANNER



Oracle Database 10g Enterprise Edition Release 10.2.0.1.0 - Prod PL/SQL Release 10.2.0.1.0 - Production
CORE 10.2.0.1.0 Production
TNS for 32-bit Windows: Version 10.2.0.1.0 - Production NLSRTL Version 10.2.0.1.0 - Production

SQL> conn ***/***@10standart
Connected.
SQL> select * from PRODUCT_COMPONENT_VERSION;

PRODUCT



VERSION

STATUS

NLSRTL
10.2.0.1.0
Production

Oracle Database 10g
10.2.0.1.0
Production

PL/SQL
10.2.0.1.0
Production

TNS for 32-bit Windows:
10.2.0.1.0
Production

Elapsed: 00:00:00.03
SQL> select * from v$version;

BANNER



Oracle Database 10g Release 10.2.0.1.0 - Production PL/SQL Release 10.2.0.1.0 - Production
CORE 10.2.0.1.0 Production
TNS for 32-bit Windows: Version 10.2.0.1.0 - Production NLSRTL Version 10.2.0.1.0 - Production

BTW if I remember correctly some months(weeks???) ago there was similar discussion here.

Gints Plivna
http://www.gplivna.eu

2007/6/28, Neil Overend <neiloverend_at_gmail.com>:
> We have records that say it is the Standard Edition, but given my
> experrience I don't believe them :-)

--
http://www.freelists.org/webpage/oracle-l
Received on Thu Jun 28 2007 - 08:33:11 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US