Re: Very long "WHERE" list.

From: Bricklen <bricklen-rem_at_yahoo.comz>
Date: Thu, 08 Jul 2004 16:47:09 GMT
Message-ID: <hUeHc.9535$Rf.7508@edtnps84>

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. Received on Thu Jul 08 2004 - 11:47:09 CDT