Query for doing pagination in Oracle

Asked Dec 20 '14 at 08:41

Active Dec 20 '14 at 09:54

Viewed 34 times

I have a query in mysql to do pagination using start index and no of records per page, the query is

SELECT * FROM TABLE LIMIT STARTINDEX, PAGESIZE.

This is working really fine with a MySQL database. But I have to do same thing with an Oracle database.

However, this query is does not work in Oracle. Can someone give a query which works in Oracle using start index and page size?

There are other questions which has taken many conditions but I want to use only start index and page size options.

edited Dec 20 '14 at 09:54

Lee Taylor

asked Dec 20 '14 at 08:41

abey

What version of Oracle? – Justin Cave Dec 20 '14 at 08:53
can you provide link to that question.. – abey Dec 20 '14 at 09:05
The link is added automatically to your question. – Justin Cave Dec 20 '14 at 09:06
There it was taken many conditions but I want to build a query only using start index and page size... – abey Dec 20 '14 at 09:19
Sorry, I'm not seeing how that is a different question. You'd just need to compute the end row based on the start row and the page size. – Justin Cave Dec 20 '14 at 09:36
Take a look at this question too: http://stackoverflow.com/questions/22035165/select-range-limit-of-results-in-oracle-sql-pagination – Sylvain Leroux Dec 20 '14 at 10:35

0 Answers0