title: Ibatis and Oracle limit resultset
body: <p>i have to change a sql mapping in Ibatis an I want to limit the resultset to 1000 rows for every of tipe "list".</p>
  
  <p>I tried this:</p>
  
  <pre><code>&lt;select id="list" parameterClass="common.dto.Dto" resultClass="common.Entity"&gt;
          SELECT *
          FROM table SOC
          LEFT OUTER JOIN SOCIETASEP SEP
          ON SEP.COSOCIETA = SOC.CODSOCIETA
  
          &lt;dynamic prepend="WHERE"&gt;
  
          ROWNUM&amp;lt;=1000
  
      &lt;isNotEmpty prepend="AND" property="ragSoc"&gt;
          DSRAGSOC LIKE UPPER(#ragSoc#) || '%'
      &lt;/isNotEmpty&gt;
          &lt;/dynamic&gt;
  &lt;/select&gt;
  </code></pre>
  
  <p>But doesn't work. Ho to insert a static condition?</p>
  
  <p>Thanks</p>