Variable where clause

  • From: Ranko Mosic <ranko.mosic@xxxxxxxxx>
  • To: oracle-l@xxxxxxxxxxxxx
  • Date: Tue, 14 Jun 2005 18:01:03 -0400

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.
--
//www.freelists.org/webpage/oracle-l

Other related posts: