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

Home -> Community -> Mailing Lists -> Oracle-L -> Variable where clause

Variable where clause

From: Ranko Mosic <ranko.mosic_at_gmail.com>
Date: Tue, 14 Jun 2005 18:01:03 -0400
Message-ID: <367369f105061415017d31e982@mail.gmail.com>


Hi all,=20
I have to write pl/sql proc that will return cursor.=20 Input parameters could be 1) map, 2) map, map_division or 3) map, map_division, map_subdivision.
I don't want to write separate procedures for each input parameter combinat= ion.=20
Input parameters will be matched against portions of 19 char string,=20 for example substr(roll, 4, 3) =3D map

                  substr(roll, 7, 3) =3D map_division

How do I do this ?=20

Regards, Ranko.

--
http://www.freelists.org/webpage/oracle-l
Received on Tue Jun 14 2005 - 18:06:15 CDT

Original text of this message

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