OraFAQ Forum: SQL & PL/SQL » Fast query paging for large table

Home » SQL & PL/SQL » SQL & PL/SQL » Fast query paging for large table (Oracle 12c,Oracle Linux 6.4)

Tue, 09 June 2015 02:19

fabi88
Messages: 112
Registered: November 2011

Senior Member

Hi,

can anyone introduce me a fast query paging for large table which we can specify the page number and the number of records per page(page size)?

Tue, 09 June 2015 02:39

Michel Cadot
Messages: 68645
Registered: March 2007
Location: Nanterre, France, http://...

Senior Member
Account Moderator

have a look at row_limiting_clause in SQL Reference.

Tue, 09 June 2015 03:12

fabi88
Messages: 112
Registered: November 2011

Senior Member

Thank you,

is there other method that we can use it for previous oracle version such as 11g?

Tue, 09 June 2015 03:21

Michel Cadot
Messages: 68645
Registered: March 2007
Location: Nanterre, France, http://...

Senior Member
Account Moderator

You have to use ROW_NUMBER function (which is the way Oracle actually uses behind the "row_limiting_clause").

Previous Topic:	ORA-30036 while running a Procedure
Next Topic:	cumulative sum

Goto Forum:

]

Current Time: Thu Apr 25 09:29:43 CDT 2024