Re: Very long "WHERE" list.

From: Paul Drake <bdbafh_at_gmail.com>
Date: 9 Jul 2004 07:45:16 -0700
Message-ID: <910046b4.0407090645.1846ffd3@posting.google.com>

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)

Pd Received on Fri Jul 09 2004 - 09:45:16 CDT