摘要： oracle分页显示方法 一、使用rownum分页显示方式方式1：SELECT * FROM (SELECT ROWNUM r, a.* FROM b$i_exch_info a WHERE ROWNUM <= 10)WHERE r >= 5;方式2：SELECT * FROM (SELECT ROWNUM r, a.* FROM b$i_exch_info a)WHERE r BETWEEN 5 AND 10;方式3： SELECT * FROM b$i_exch_info WHERE ROWNUM <= 10 MINUSSELECT * FROM b$i_exch_inf 阅读全文