From SQL> How to query Oracle version?

From: Cheong <ccheong_at_my.lhsgroup.com>
Date: Mon, 13 Sep 1999 17:33:31 +0800
Message-ID: <37dcbf13@news.lhsgroup.com>

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 - 04:33:31 CDT