ibatis查询oracle分页配置

最近做一个java项目，使用ibatis与数据库连接，我现在知道在mysql数据库的时候，配置sql分页是用
XML code:

<sql id="pageSql">
<dynamic>
<isNotNull property="startIndex">
<isNotNull property="pageSize">
limit #startIndex# , #pageSize#
</isNotNull>
</isNotNull>
</dynamic>
</sql>



我现在用的是oracle数据库，请问应该怎么配置这个分页呀？

---

自己解决了，呵呵

---

贴出来看看

---

select * from (select rownum as minRownum, u.* from ( select * from user)
) u
<dynamic prepend="where">
    <isGreaterThan prepend="and" property="maxRownum" compareValue="0">
<![CDATA[ rownum <=#maxRownum# ]]>
    </isGreaterThan>
</dynamic>
  ) t where
<![CDATA[t.minRownum>#minRownum#]]>

---

恭喜一下，把解决方法贴出来分享一下

---

XML code:

[code=XML]
<sql id="paginationStart">select b.* from (select a.*,rownum as linenum from (</sql>
- <sql id="paginationEnd">
- <dynamic>
- <isNotNull property="startIndex&