Re: From SQL> How to query Oracle version?

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 - 17:36:17 CEST