Re: From SQL> How to query Oracle version?

hello,

try the following from inside SQL*Plus :

select * from v$version ;

catching that output you can grep on the wanted information.

best regards

burkhard schneider

Cheong schrieb:
>
> 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 Wed Sep 15 1999 - 22:57:34 CEST