How to put more than 1000 values into an Oracle IN clause

oracle in-clause
Aaron Palmer picture Aaron Palmer · Dec 30, 2008 · Viewed 305.9k times · Source

Is there any way to get around the Oracle 10g limitation of 1000 items in a static IN clause? I have a comma delimited list of many of IDs that I want to use in an IN clause, Sometimes this list can exceed 1000 items, at which point Oracle throws an error. The query is similar to this...

select * from table1 where ID in (1,2,3,4,...,1001,1002,...)

Answer

Otávio Décio picture Otávio Décio · Dec 30, 2008

Put the values in a temporary table and then do a select where id in (select id from temptable)

Related questions

Oracle - In CLAUSE question when using with multiple values, making it dynamic

I just spent an hour on google and here trying to get a straight answer for how to do this in Oracle. What I need is the ability to use select in clause that constructed automatically such as select col1 …

Read More
Oracle "IN clause" from parameter

I'm very unfamiliar with Oracle and am just trying to get this to work. I've looked here and here but have no idea how to make it all work. Here's what I need. I need a proc that will accept …

Read More
Get list of all tables in Oracle?

How do I query an Oracle database to display the names of all tables in it?

Read More