SELECT T2.* FROM(
SELECT T.*, ROWNUM RN FROM(
SELECT * FROM (SELECT * FROM table) ORDER BY col
)T) T2 WHERE RN BETWEEN (page-1)*size+1 AND page*size
SELECT T2.* FROM(
SELECT T.*, ROWNUM RN FROM(
SELECT * FROM (SELECT * FROM table) ORDER BY col
)T) T2 WHERE RN BETWEEN (page-1)*size+1 AND page*size