Oracle uses rownum for paginating queries. If order by clause can not unique order records ie. if all records have same first , last name and we are ordering by first,last name, then different pages may get same records.
here is good post
http://www.oracle.com/technology/oramag/oracle/06-sep/o56asktom.html
Monday, July 13, 2009
Subscribe to:
Posts (Atom)