Re: Very long "WHERE" list.

gumenyuk_at_canada.com (Serguei) wrote in message news:<c1e8f29a.0407080842.557330e1_at_posting.google.com>...
> Dear Experts,> I have to execute a SELECT statement with a very long "IN" list with> several thousands of values:> > SELECT something FROM table WHERE id IN (1,3,5, ...., 20001)> > Unfortunately Oracle can not process this request directly. Is there> any way to by path this limitation?> Regards,> Serguei.

multiple IN lists each seperated by an OR, perhaps?
(please don't ask why I know this)