Oracle常用分页语句性能比较
分页一：
select * from( select rid,num from ( select rid,rownum num from ( select rowid rid from xg.sys_operators t order by to_number(t.op_id) ) a where rownum <= 5000 ) b where num > 4990) c,xg.sys_operators swhere c.rid = s.rowid order by c.num
