Content
Comments (0)
In some projects with php and Oracle I always have question...
Can a make paging with oracle? Something like LIMIT in MYSQL?
With this sub query you can do it easy.
select o.* from (select rownum RWID , o.* from (
SELECT * FROM TABLENAME
) o where rownum <= 40 ) o where o.RWID >= 30
SELECT * FROM TABLENAME
) o where rownum <= 40 ) o where o.RWID >= 30