Re: Which Version of Oracle is it?

select * from v$version

Hth,

Sybrand Bakker, Oracle DBA

<sumanp_at_my-deja.com> wrote in message news:8arhms$5rj$1_at_nnrp1.deja.com...
> 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.
Received on Thu Mar 16 2000 - 00:00:00 CST