Re: Oracle version

Many thanks to everybody.
First reply of Howard was all I needed..

gigione.

"Ed Stevens" <nospam_at_noway.nohow> ha scritto nel messaggio news:0v3f90tlcq4bojg564vjak0k4q8809n5kf_at_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 Wed May 05 2004 - 03:36:03 CDT