Posts Oracle pagination
Post
Cancel

Oracle pagination

1
2
3
4
5
6
--http://viralpatel.net/blogs/oracle-pagination-using-rownum-limiting-result-set/
  select * 
      from ( select a.*, rownum rnum
         from ( select * from the_owner.x where IDENTIFIER='1' and source = 'x' order by 1) a
         ) 
    where rnum > 3 and rnum < 15

origin - http://www.pipiscrew.com/?p=9990 oracle-pagination

This post is licensed under CC BY 4.0 by the author.
Contents

Trending Tags