Now let say you want to do pagination in your application. For that requirement would be to get data from database in slots. For example, in first page first 10 records are displayed and on second page next 10 records are displayed.
Query to get first 10 record would be:
select name, age
select rownum r, name, age
where r > 0 and
r < 11;