Oracle Learning Eight paging (using RowNumber) (continuous)

RowNumber is a query of the dataset after adding a pseudo-column (continuous) to use it to produce a page based on an Oracle database, with statements similar to formulas that are directly applied as follows:

Select *  from (Select from (select*fromorder by ProcID))  where R between (pageindex-1)*+1and pageindex*pagesize

Where pageindex is the page number, pagesize is the maximum number of pages per page

Oracle's between. and.. Both front and back are closed intervals, which means that there are two-end numbers.

One more word: between and is the opposite of not between. And,

Not between. and.. Just take the opposite range of the specified range, that is, a record that is not in this range, and the user can replace it with a logical set of conditions.

Between and represents >= or <=, then not between. and.. means < or >.

Oracle Learning Eight paging (using RowNumber) (continuous)