高效oracle分页

清华大佬耗费三个月吐血整理的几百G的资源,免费分享!....>>>

  SELECT * FROM (SELECT ROWNUM AS ROWNO,t.* FROM INFO_USER_BASIC t WHERE t.STATUS=1 AND ROWNUM <= 13) ub  WHERE UB.ROWNO >=0;