I would agree with always looking at v$instance, then you can make sure
you've sqlplus'ed into the right database. But in reference to Blanc's
response, when you do sqlplus into an instance you see both the sqlplus
release you are using and the oracle release so that could work if all you
wanted to know was the release .
"damorgan" <dan.morgan_at_ci.seattle.wa.us> wrote in message
news:3C640836.AF8E5BE2_at_ci.seattle.wa.us...
> Or v_$instance.
>
> Daniel Morgan
>
>
> BLANC Philippe wrote:
>
> > no sqlplus can be updated,
> > You can use a sqlplus version 8 on a database version 7
> >
> > you have to do select * from v$version in order to have the database
version
> >
> > "S.M." <nobody_at_no.com> a écrit dans le message de news:
> > a3rnen$70r$1_at_pheidippides.axion.bt.co.uk...
> > > Hi
> > > How do I know what version of oracle I am running?
> > > Is it the version number that come sup when I sqlplus onto the
database?
> > >
> > > Thanks
> > > S
> > >
> > >
>
Received on Fri Feb 08 2002 - 12:20:16 CST
