페이징 쿼리문

SELECT
A.*
FROM
(
    SELECT
         ROWNUM AS RNUM
        ,A.*
    FROM
    (
        SELECT
             COUNT(*) OVER()        AS TOTALCOUNT
            ,A.SEQ_NO                AS SEQUENCE_NO  --시퀀스번호
            ,IN_PAGE
            ,IN_ROWS_PAGE
        FROM
            TABLE_1 A      --HM_ErrorLog
            ,(SELECT
                 TO_NUMBER(:v_page) IN_PAGE
                ,TO_NUMBER(:v_rows_page) IN_ROWS_PAGE
              FROM DUAL)
        ORDER BY A.SEQ_NO DESC
    ) A
    WHERE ROWNUM <= IN_ROWS_PAGE  * IN_PAGE
) A
WHERE     CEIL(RNUM/ IN_ROWS_PAGE ) = IN_PAGE