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;