오라클 페이징 처리

<sql id="oraclePageHeader">
        <isNotEqual property="pagesize" compareValue="0">
        SELECT *
          FROM (SELECT ROWNUM AS rowindex,
                       original.*
                  FROM (
        </isNotEqual>   
    </sql>
   
    <sql id="oraclePageFooter">
        <isNotEqual property="pagesize" compareValue="0">
            ) original
        ) WHERE rowindex BETWEEN (#pageno# * DECODE (#pagesize#, 0, 10, #pagesize#) + 1)
                                           AND ( (#pageno# + 1) * DECODE (#pagesize#, 0, 10, #pagesize#))
        </isNotEqual>   
    </sql>