Re: limits to select/where/in statement??

Thanks.

"Jim Kennedy" <kennedy-family_at_attbi.com> wrote in message news:rrsP7.1455$802.120353_at_rwcrnsc53...
> I believe in 8i the limit is 255 or 256. So yes 500 would be a problem.
> Jim
> "Doug" <kark_1999_at_yahoo.com> wrote in message
> news:xlsP7.1714$5W5.842404_at_typhoon.ne.mediaone.net...
> > Does anybody know if there is a limit to the number of "in" values you
 can
> > have?
> > For example,
> > delete from customers where cust_no in (5343,2356,23467,23,664);
> >
> > what if I have 500 values within the parens? would this be a problem?
> > thanks.
> >
> >
>
>
Received on Wed Dec 05 2001 - 19:12:12 CET