1. Home
2. All Interview Questions
3. All Oracle Questions
4. How to put more than 1000 values into an Oracle IN clause?

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

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