Oracle数据库sql中某参数的条件个数超过1000条时怎么处理？

        int size= list.size();
        int times = 0;
        int startIndex = 0;

        for(int i = 0; i < size / 1000; i++){
            times++;
            startIndex = 1000 * i;
            List<String> userIds= list.subList(startIndex, startIndex + 1000);
            userDao.queryUser(userIds);
            ...
        }
        if(serialnoSize % 1000 > 0){
            startIndex = 1000 * times;
            List<String> userIds = serialnoList.subList(startIndex, size);
            userDao.queryUser(userIds);
            ...
        }