Shulou(Shulou.com)06/02 Report--

This article mainly explains the "Oracle paging query method is what", the article explains the content is simple and clear, easy to learn and understand, the following please follow the editor's ideas slowly in-depth, together to study and learn "Oracle paging query method is what" it!

Preface

Earlier, we introduced the parallel query of Oracle. We originally intended to use parallel query to solve the method of getting all the data, but after testing, we found that it did not achieve the desired effect, so we still have to prepare to use paging for query.

Paging query

In Oracle, you do not want to filter the Limit method in MySql, so it is more troublesome to realize the paging query. You need to sort the rows with the original table and then use rownum to deal with the paging.

Oracle paging query statements can basically be applied according to the format given in this article.

Oracle paging query format:

The innermost query SELECT * FROM TABLE_NAME represents the original query statement that does not turn the page. ROWNUM = 21 controls the scope of each page of the paging query.

The Oracle paging query given above is efficient in most cases. The purpose of paging is to control the size of the output result set and return the results as soon as possible. In the paging query above, this consideration is mainly reflected in WHERE ROWNUM

Welcome to subscribe "Shulou Technology Information " to get latest news, interesting things and hot topics in the IT industry, and controls the hottest and latest Internet news, technology news and IT industry trends.