High-efficiency SQL paging in Oracle, including Informix Paging

The efficiency of interviewing Oracle pages is higher than that of traditional pages, but the disadvantage is that when querying the last page, the efficiency is the same as that of traditional pages.
Select * from
(Select rownum RN, A. * from (select int_id from cell) A where rownum <= (page number + data volume per page ))
Where rn> = (page number + 1)

Page usage of Informix:
SelectSkip mFirst
N *FromTablename where M is the page number (starting from 0) and N is the number of records per page