Re: Function to get partial Oracle version

From: Mark C. Stock <mcstockX_at_Xenquery>
Date: Thu, 23 Mar 2006 11:44:50 -0500
Message-ID: <XPOdnYUGEvkfTb_ZnZ2dnUVZ_vudnZ2d@comcast.com>

"Luis Santos" <lcdsantos_at_gmail.com> wrote in message news:1143129863.120882.148230_at_e56g2000cwe.googlegroups.com...
: Does anyone has a function which returns the Oracle host version, but
: with flexible partial version, just like this
:
: SQL> select version(5) from dual;
:
: VERSION
: ---------
: 7.3.1.4.0
:
:
: SQL> select version(2) from dual;
:
: VERSION
: ---------
: 9.2
:
:
: SQL> select version(3) from dual;
:
: VERSION
: ---------
: 10.2.0
:

use SUBSTR and INSTR

++ mcs Received on Thu Mar 23 2006 - 10:44:50 CST