How to split array list into equal parts?

java, oracle10g, plsql

Solution

This should give you all your parts:

int partitionSize = 1000;
List<List<Integer>> partitions = new LinkedList<List<Integer>>();
for (int i = 0; i < originalList.size(); i += partitionSize) {
    partitions.add(originalList.subList(i,
            Math.min(i + partitionSize, originalList.size())));
}

Problem

Is there anyway to split ArrayList into different parts without knowing size of it until runtime? I know there is a method called: ``` list.subList(a,b); ``` but we need to explicitly mention staring and ending range of list. My problem is, we get a arraylist containing account numbers which is having data like 2000,4000 account numbers (there numbers will not be known during coding time), and I need to pass this acc nos into IN query of PL/SQL, as IN doesn't support more than 1000 values in it, I am trying to split into multiple chunks and sending it to query Note: I cannot use any external libraries like Guava etc.. :( Any guide in this regard is appreciated.

Original source