SQL使用IN超过1000个条件的处理

> ORA-01795: maximum number of expressions in a list is 1000

SELECT* FROM tableName WHERE ID IN('1','2','...','1001');改成下面的方式：
SELECT* FROM tableName WHERE (0,ID) IN((0,'1'),(0,'2'),(0,'...'),(0,'10001'));

	String str = "1,2,...,1001";StringBuffer sb = new StringBuffer();if (StringUtils.isNotEmpty(str)) {sb.append("(");String[] split = str.split(",");int length = split.length;for (int i = 0; i < length; i++) {sb.append("(0,'");sb.append(split[i]);sb.append("'),");}sb.append(")");sb.deleteCharAt(sb.toString().length() - 2);}System.out.println(sb.toString());// ((0,'1'),(0,'2'),(0,'...'),(0,'1001'))