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

From: Jim Kennedy <kennedy-family_at_attbi.com>
Date: Wed, 05 Dec 2001 17:03:19 GMT
Message-ID: <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 - 18:03:19 CET

Original text of this message