Re: Which Version of Oracle is it?

SELECT *
FROM v$version;

Ask your DBA to create a PUBLIC SYNONYM if it doesn't already exist (base table is v_$version in SYS schema).

and hey presto, you get

Oracle8 Enterprise Edition Release 8.0.5.0.0 - Production PL/SQL Release 8.0.5.0.0 - Production
CORE Version 4.0.5.0.0 - Production
''''
''''
etc.

David P.

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.
  Received on Fri Mar 17 2000 - 00:00:00 CST