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

Home -> Community -> Usenet -> c.d.o.server -> Re: Oracle version

Re: Oracle version

From: Ed Stevens <nospam_at_noway.nohow>
Date: Tue, 04 May 2004 07:51:48 -0500
Message-ID: <0v3f90tlcq4bojg564vjak0k4q8809n5kf@4ax.com>


On Tue, 04 May 2004 21:46:54 +1000, "Howard J. Rogers" <hjr_at_dizwell.com> wrote:

>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
Of course, that will only tell about what is running the database to which one is currently connected.

I have always been fascinated by how different people see the same question, but read it differently. When the op said "if there is installed" you obviously thought along the lines of "what is this database running under?" I thought something along the lines of "what versions of Oracle (possible multiple homes?) are installed and available for building a database?" I can't imagine any query that would answer that question, and would guess the best bet there would be to go tot he OUI and see what it might report.

So it goes back to the op to clarify his question? Received on Tue May 04 2004 - 07:51:48 CDT

Original text of this message

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