Re: IN Lists

From: William Robertson <williamr2019_at_googlemail.com>
Date: Sat, 21 Feb 2009 15:49:57 -0800 (PST)
Message-ID: <20581062-ca00-4b35-bcef-57ec08cd0f87_at_g38g2000yqd.googlegroups.com>

On Feb 18, 6:54 am, William Robertson <williamr2..._at_googlemail.com> wrote:
> On Feb 17, 7:47 pm, Mtek <m..._at_mtekusa.com> wrote:
>
> > Sheesh, how hard can this be:
>
> >      IF p_code IN v_code_list THEN
> >         v_query := v_query || ' AND p_code IN v_code_list';
> >      END IF;
>
> > Does not like that.  The IN list will be dynamic.......
>
> Try using collections and the MEMBER OF operator.http://www.williamrobertson.net/documents/comma-separated.html
>
> > Oracle is being picky here......
>
> Is there any programming language in which a comma-separated string
> works the way you just made up?

I guess not. Received on Sat Feb 21 2009 - 17:49:57 CST