Paging solution for Oracle

xiaoxiao2021-03-06  54

TotalPage: Total Pages -

Totalpage = (count globalconst .page_size -1) / globalconst .page_size;

Where COUNT is the current total number of records.

CURRPAGE: Current page When the value is 0PAGENO: Maximum number of records per page When Currpage> 0 When Currpage

Select * from (select Tab. *, Rownum rr from tab where rownum <= pageno * (currpage 1)) B Where b.r> Pageno * Currpage;

转载请注明原文地址:https://www.9cbs.com/read-117003.html

New Post(0)