Oracle paging SQL

During the project transformation, the paging data written by the original colleague is to query all records from the database and then to the paging data. Now, the paging data is transformed to dynamically querying the split pages and the number of records.

// Query 100th to 199th records

Select * from (select B. *, rownumber rn from (select * from a) B where B. Rn> = 100) Where rn <= 199

 

From the preceding Query format, the number of records in the middle of the Oracle table must be nested with at least three subqueries. If it is connected to other tables, the last join query can be viewed as Table. The slower the query is.

The Performance Comparison Between the paging of the Oracle stored procedure and the paging of the SQL script will be provided later.