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