Re: Very long "WHERE" list.

Bricklen <bricklen-rem_at_yahoo.comz> wrote:

>Serguei wrote:
>
>> 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.
>Put them in a table and use it as a lookup table, or possibly a global
>temporary table if you must.

But, what kind of query would need that many IN values and how are they entered?( how many possible values are there?would a NOT IN work ?)
Does someone actually type in several thousand values? Received on Thu Jul 08 2004 - 12:01:01 CDT