From SQL> How to query Oracle version?

[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