New Features of Oracle 12c: Paging Query

The new feature of Oracle 12c paging query is expected in the upcoming oracle 12c release. This is the optimization of paging query. There are many paging query functions in the application. Previously we used rownum for this purpose.
For example, to query 1-10 records, the query statement is as follows: www.2cto.com SQL code select * from (select row _. *, rownum _ from (select doc_id, title, title_color, title_striking, upload_date, editor from ttt_doc) order by upload_date desc) row _ where rownum <= 10) where rownum _> 0; www.2cto.com is in 12c. You can do this. SQL code select doc_id, title, title_color, title_striking, upload_date, editor from ttt_doc order by upload_date desc fetch first 10 rows only; if you want to query 11 to 20 records, then you can do this. Www.2cto.com SQL code select doc_id, title, title_color, title_striking, upload_date, editor from ttt_doc order by upload_date desc offset 10 rows fetch next 10 rows only; this is more convenient than the previous operations. Of course, the more important thing is that the performance will be greatly improved. For more information, see the oracle 12c documentation.