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_at_news.lhsgroup.com>



Hello:

[Quoted] [Quoted] From SQL> prompt, I had to run the following "script" to get what Oracle [Quoted] 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 - 11:33:31 CEST

Original text of this message