Re: Which Version of Oracle is it?

From: Colin Davies <Colin_Davies_at_excite.com>
Date: 2000/03/23
Message-ID: <8bf0ec$1aah$1@nntp1.interworld.net>#1/1

select * from v$database

"Connor McDonald" <connor_mcdonald_at_yahoo.com> wrote in message news:38D205B2.6134_at_yahoo.com...
> sumanp_at_my-deja.com wrote:
> >
> > When I am logged on into an Oracle user,
> > using SQL *Plus or TOAD,
> > how do I know, which version
> > of Oracle (7.3 or 8) am I logged into?
> >
> > Is there a system table that
> > I can query to find out
> > the Oracle Version number?
> >
> > Thanks.
> >
> > Sent via Deja.com http://www.deja.com/
> > Before you buy.
>
> select * from v$version
> --
> ===========================================
> Connor McDonald
> http://www.oracledba.co.uk
>
> We are born naked, wet and hungry...then things get worse
Received on Thu Mar 23 2000 - 00:00:00 CST