Re: Very long "WHERE" list.

From: Jim Kennedy <kennedy-downwithspammersfamily_at_attbi.net>
Date: Fri, 09 Jul 2004 01:26:36 GMT
Message-ID: <cvmHc.46809$IQ4.36301@attbi_s02>

"Serguei" <gumenyuk_at_canada.com> 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.

Go to asktom.oracle.com and do a search. I believe one way is to send in a comma delimited list into a pl/sql function and have it return an object table. So you could do an in on that.
Jim Received on Thu Jul 08 2004 - 20:26:36 CDT