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>