Re: PLSQL /Enumeration

Dont think so, only as part of a SELECT statement.

I have a function which does what you want in PL/SQL

IF IS_IN ('a,b,c,d', var1)
THEN
etc.

• Cut =============

   FUNCTION Is_In (v_sentence IN VARCHAR2, v_search IN VARCHAR2) RETURN BOOLEAN IS

   BEGIN

     IF LENGTH (v_sentence) <> LENGTH(REPLACE(v_sentence, v_search, '')) THEN
        RETURN FALSE;
     ELSE
        RETURN TRUE;
     END IF;

   END Is_In;

HTH, M

Kevin Robinson <kevin.s.robinson_at_bt.com> wrote in message news:<3CE4B352.FFF1457D_at_bt.com>...
> Does anyone know if its possible to do the following in PLSQL.
>
> IF var1 IN ( a , b , c , d)
> THEN
> etc.
>
>
> Thanks
>
> Kevin
Received on Fri May 17 2002 - 09:10:38 CDT