title: sql (oracle) to select the first 10 records, then the next 10, and so on
body: <p>I figure I might just be missing some obvious syntax but what is the sql (oracle) to select the first 10 records, then the next 10, and so on?</p>
  
  <p>I tried using rownum but can seem to get rownum > X and rownum &lt; Y to work.</p>
  
  <p>llcf</p>