Re: Oracle version

From: Howard J. Rogers <hjr_at_dizwell.com>
Date: Tue, 04 May 2004 21:46:54 +1000
Message-ID: <409782a5$0$20347$afc38c87@news.optusnet.com.au>

gigione wrote:
> Hello everybody.
> Is there an SQL command telling me if there is installed Standard or
> Enterprise version of Oracle 9.2 installed on a windows 2000 server?
>
> If there isn't, how can I know it? Where must I look for?
> I found the key ORACLE_BUNDLE_NAME in the registry, but I don't know if
> this is correct.
>
> thank's a lot.
>
> Sam.
>
>

select * from v$version;
BANNER

---

Oracle9i Enterprise Edition Release 9.2.0.1.0 PL/SQL Release 9.2.0.1.0 - Production
CORE 9.2.0.1.0 Production
TNS for 32-bit Windows: Version 9.2.0.1.0 - P NLSRTL Version 9.2.0.1.0 - Production

...where the first line of the BANNER says it all.

Somewhat more subtly, try:

SQL> select * from v$option

   2 where parameter = 'Partitioning';

PARAMETER

---

VALUE

---

Partitioning
TRUE ...which, being an Enterprise Edition only feature, could only be TRUE if you've got the Enterprise Edition.

Regards
HJR Received on Tue May 04 2004 - 06:46:54 CDT