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
Subscribe to:
Post Comments (Atom)
No comments:
Post a Comment