title: How to split up a massive data query into multiple queries
body: <p>I have to select all rows from a table with millions of rows (to preload a Coherence datagrid.)  How do I split up this query into multiple queries that can be concurrently executed by multiple threads?  </p>
  
  <p>I first thought of getting a count of all records and doing:</p>
  
  <pre><code>SELECT ... 
  WHERE ROWNUM BETWEEN (packetNo * packetSize) AND ((packetNo + 1) * packetSize)
  </code></pre>
  
  <p>but that didn't work.  Now I'm stuck.  </p>
  
  <p>Any help will be very appreciated.</p>