Re: From SQL> How to query Oracle version?

Select * from V$version;

or

Select Substr(Banner,1,least(instr(banner,'.')+7,64)) from V$VERSION where Instr(Upper(Banner),'ORACLE')>0;

In article <37dcbf13_at_news.lhsgroup.com>, Cheong <ccheong_at_my.lhsgroup.com> 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
>/
>+++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++
Received on Mon Sep 13 1999 - 19:23:08 CEST