Re: Very long "WHERE" list.

gumenyuk_at_canada.com (Serguei) writes:

> 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.

• create and populate table __table_with_values__
• with required values

SELECT something FROM table WHERE id IN

    (select value from __table_with_values__)

-- 
Misha Polatov
MetaCommunications Engineering