Arizona State University Interview Question
How would you paginate results in a Oracle result set?
Interview Answer
Anonymous
May 9, 2014
Unlike MySQL, there's no LIMIT clause. You can use oracle's ROWNUM to specifiy a greater than or less than condition, but you'll have to query the result set twice to build the upper and lower bounds.
1