Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Function to get partial Oracle version

Function to get partial Oracle version

From: Luis Santos <lcdsantos_at_gmail.com>
Date: 23 Mar 2006 08:04:23 -0800
Message-ID: <1143129863.120882.148230@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 Received on Thu Mar 23 2006 - 10:04:23 CST

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US