oracle分页查询SQL模板

<select id="getDataList" resultMap="BaseResultMap">
    SELECT
    *
    FROM
    (
    SELECT
    TMP_PAGE.*,
    ROWNUM ROW_ID
    FROM
    (
      #查询语句
    SELECT * 
    FROM TABLE
    )TMP_PAGE
    WHERE ROWNUM <![CDATA[ < ]]> ((#{pageNum} + 1) * #{pageSize} + 1)
    )
    WHERE ROW_ID <![CDATA[ > ]]> ((#{pageNum} + 1) * #{pageSize} - #{pageSize})
  </select>