title: Get 1000 row set from Oracle table
body: <p>I want to select 1000 rows at a time using the query:</p>
  
  <pre><code>SELECT * FROM MEMBERID_1M WHERE ROWNUM &lt;1000
  </code></pre>
  
  <p>How do I get the next set of 1000 rows from this table in a for loop?</p>