Re: IN Lists
Date: Tue, 17 Feb 2009 22:54:26 -0800 (PST)
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? Received on Wed Feb 18 2009 - 00:54:26 CST