pl/sql 分页语句 关键是利用伪列rownum(从1开始计数)进行分页,格式如下:select * from (select pagination.*,rownum page from (select * from a) pagination where rownum<上限) where page>下限