Oracle where in 超过1000条的解决方法思路
1.使用or操作符
select *
from a
where a.no = '' or
a.no = '' or
a.no = '' or
a.no = '' or
........
a.no = '';
2.使用临时表
1)create table b (no number);
2)把数据导入到b表中
3)select *
from a,b
where a.no = b.no;
http://blog.csdn.net/honganboy/article/details/6831759
