Re: IN clause with more than 999 elements

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 Received on Thu Sep 18 2003 - 00:00:50 CDT