RE: piece-wise return of records from table

From: Jacques Kilchoer <Jacques.Kilchoer_at_quest.com>
Date: Tue, 22 Jul 2003 17:54:38 -0700
Message-Id: <25988.338997@fatcity.com>

Tom Kyte to the rescue!
getting rows N through M of a result set http://asktom.oracle.com/pls/ask/f?p=4950:8:::NO::F4950_P8_DISPLAYID,F4950_P8_CRITERIA:127412348064, or
http://tinyurl.com/hqsl

(You can ignore the little argument on that page where Mr. Kyte lays down the law about not using abbreviations like "u r" for "you are".)

-----Original Message-----
From: VIVEK_SHARMA [mailto:VIVEK_SHARMA_at_infosys.com]

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 - 19:54:38 CDT