jQuery PHP Oracle Scroll to bottom load data

Question

I'm using jQuery scroll bottom to load data getting from PHP + Oracle.

I tried to googling it but only show result for MySQL

//MySQL
$limitStart = $_POST['limitStart'];
$limitCount = 6;

$query = "SELECT id, name FROM countries ORDER BY name limit $limitStart, $limitCount";

Now I want it query using ORACLE query

$query = "SELECT id, name FROM countries ORDER BY name WHERE ROWNUM <= '$limitCount';

How to do that? to set the $limitstart?

Thanks

Possible duplicate of [How to add offset in a "select" query in Oracle 11g?](http://stackoverflow.com/questions/27099414/how-to-add-offset-in-a-select-query-in-oracle-11g) — timclutton, Mar 20 '17 at 09:51

score 0 · Answer 1 · answered Mar 20 '17 at 06:09

Try this,

$query = "SELECT id, name FROM countries ORDER BY name
          OFFSET $limitStart ROWS FETCH NEXT $limitCount ROWS ONLY";

1 Answers1