piece-wise return of records from table

[VIVEK_SHARMA]

CASE   select * from table gives  1000 records (say) We want only first ten of these records to be returned to the front end & then records 11 to 20 & so on …   How may the above be optimally possible ? SQL or PL/SQL any for it ?   Thanks