Re: From SQL> How to query Oracle version?

From: Thiru <tmgn_at_excite.com>
Date: Mon, 13 Sep 1999 11:36:17 -0400
Message-ID: <37DD19F1.CC7AAF4D@excite.com>

How about
>Select banner from v$version ;

-Thiru

Cheong wrote:

> Hello:
>
> From SQL> prompt, I had to run the following "script" to get what Oracle
> version I am currently running on (by supplying a known table name).
>
> Is there another simpler select statement (or describe, or whatever within
> SQL>) that can tell what Oracle version I am currently using (without having
> to exit SQL*Plus and invoke SVRMGRL)?
>
> +++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++
> COLUMN sysdate NOPRINT HEADING ''
>
> TTITLE 'Oracle Release: ' SQL.RELEASE
>
> SELECT sysdate
> FROM sys.dual
> /
> +++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++
>
> Thank you all and have a nice day!
>
> Regards,
> Cheong
Received on Mon Sep 13 1999 - 10:36:17 CDT