Re: Which Version of Oracle is it?

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