Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
![]() |
![]() |
Home -> Community -> Mailing Lists -> Oracle-L -> RE: piece-wise return of records from table
Hi,
any chance that you let us know what your front end is?
Web? CS-Forms? <fill_in_the_appropriate>?
Come on, some more infos. Typing isn't that hard ;-)
>>> VIVEK_SHARMA_at_infosys.com 22.07.2003 14.49 Uhr >>>
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 ? Received on Tue Jul 22 2003 - 07:06:08 CDT
![]() |
![]() |