Oracle分页SQL

```java
 SELECT
            *
        FROM
            (
                SELECT
                    item.*,
                    ROWNUM ROW_ID
                FROM
                    (
                        SELECT
                            *
                        FROM
                            TB_ITEM
                        WHERE
                             ( updatetime >= TO_DATE(#{lastTime}, 'yyyy-mm-dd hh24:mi:ss' ) AND updatetime <= TO_DATE( #{currentTime}, 'yyyy-mm-dd hh24:mi:ss' ) )
                    ) item
                WHERE
                    ROWNUM <= 1000
            )
        WHERE
            ROW_ID > 0
    </select>