title: Simple Select with where and offset fetch clause not working in oracle
body: <p>I am trying to select rows with <code>where</code> condition and will need pagination. So I have added <code>Fetch</code> with <code>offset</code>[to make it dynamic] clause but then it gives this error:</p>
  
  <blockquote>
    <p>ORA-00933: SQL command not properly ended Position: 414</p>
  </blockquote>
  
  <p>My Query:</p>
  
  <pre><code>SELECT
      up.NAME upozilaName_bn,
         up.id upozila,
      dis.NAME districtName_bn,
         dis.id district,
      dv.NAME divisionName_bn,
         dv.id division,
      w.COUNTER_TYPE, w.COUNTER_ID,
      w.STATUS
  FROM X w
  left join  Y up
      ON w.UPOZILA = up.ID
  left JOIN Z dis
      ON w.DISTRICT = dis.id
  left join  P dv
      ON w.DIVISION = dv.ID
  where 1=1  order by upozilaName_bn asc OFFSET 1 ROWS FETCH NEXT 10 ROWS ONLY;
  </code></pre>
  
  <p>Without <code>FFSET 1 ROWS FETCH NEXT 10 ROWS ONLY</code> this, it is okay! 
  I searched for that error: <code>933</code>, but no help found.
  Oracle version: 11.2g</p>