如何将1000个以上的值放入Oracle IN子句 [英] How to put more than 1000 values into an Oracle IN clause

问题描述

有什么方法可以解决静态IN子句中Oracle 10g对1000个项目的限制?我有一个逗号分隔的列表，其中包含要在IN子句中使用的许多ID，有时此列表可能超过1000个项目，这时Oracle会引发错误.查询与此类似...

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,...)

推荐答案

将值放在临时表中，然后选择id在哪里(从临时表中选择id)

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

这篇关于如何将1000个以上的值放入Oracle IN子句的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！