Re: IN clause with more than 999 elements

From: Turkbear <john.greco_at_dot.state.mn.us>
Date: Thu, 18 Sep 2003 09:22:43 -0500
Message-ID: <pqfjmv4ipfpch3t6ngn4gc3uldii61fjmf@4ax.com>

Richard Kuhler <noone_at_nowhere.com> wrote:

>laSerpe wrote:
>> How can I solve problem which Oracle IN-clause doesn't work with more than
>> 999 elements?
>> for example:
>> I want execute a query like:
>> SELECT * FROM TABLE WHERE FIELD IN (VALUE1,...VALUEn) with n>=1000
>> thank you, federica
>
>Of course there's always ...
>
>FIELD IN (VALUE1, ... VALUE1000)
>OR FIELD IN (VALUE1001, ... VALUE2000)
>etc...
>
>
>Richard Kuhler

Depending on the number of records and other fields, that combination of OR and IN could still be running when the Heat Death Of The Universe happens... ;-) Received on Thu Sep 18 2003 - 09:22:43 CDT