Check out example codes for "oracle limit rows". It will help you in understanding the concepts better.

Code Example 1

SELECT * 
FROM   sometable
ORDER BY name
OFFSET 20 ROWS FETCH NEXT 10 ROWS ONLY;

Code Example 2

oracle limit rows

Learn ReactJs, React Native from akashmittal.com