I use JDBC to retrieve Oracle database by ‘IN’ statement. But there are too many expressions, about >1000.
It looks like: 

```
SELECT * FROM MyTable WHERE name IN (?, ?, ?......); --More than 1000 question signal

```

It causes ‘*syntax error or access rule violation*’ which means ‘*maximum number of expressions in a list is 1000*’.

Do I have to do retrieve operation many times (for example, using 100 ‘?’ and retrieve 10 times) and merge the lists? 
Any better solution? Thanks!

Edit:
I have no chance to modify database which is not my work of art.