Re: IN clause with more than 999 elements

From: andrewst <member14183_at_dbforums.com>
Date: Wed, 17 Sep 2003 05:08:27 -0400
Message-ID: <3379749.1063789707@dbforums.com>

Originally posted by Laserpe

> 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

Put the n values into a table and then write:

SELECT * FROM TABLE WHERE FIELD IN (SELECT value FROM value_table);

You do not want to be putting 100 values in an IN list never mind 1000!

--
Posted via http://dbforums.com

Received on Wed Sep 17 2003 - 04:08:27 CDT