How to get the databaseversionnumber

From: Uwe Hoell <hoell_at_aaeb.de>
Date: Mon, 17 Jan 2000 10:29:09 +0100
Message-ID: <85unbj$m5q$1@newsread.do2.de.uu.net>

I need the versionnumber of the Oracleengine. Is there any view to get it? I've tested with "select banner from v$version;", but in this view the formating of the version number is different in each of the versions:

Oracle7 Workgroup Server Release 7.3.4.4.0 - Production Oracle8 Release 8.0.5.1.1 - Production
Oracle8i Enterprise Edition Release 8.1.5.0.0 - Production

I'm calling this from ODBC.

thanks! Received on Mon Jan 17 2000 - 03:29:09 CST