Message-Id: <25988.338872@fatcity.com> From: "VIVEK_SHARMA" Date: Tue, 22 Jul 2003 17:20:54 +0530 Subject: piece-wise return of records from table This is a multi-part message in MIME format. ------=_NextPartTM-000-975d9b64-98a7-49bb-9ff6-a2cbd206b64c Content-Type: multipart/alternative; boundary="----_=_NextPart_001_01C35047.81CE4F2C" ------_=_NextPart_001_01C35047.81CE4F2C Content-Type: text/plain; charset="us-ascii" Content-Transfer-Encoding: quoted-printable CASE=20 =20 select * from table gives 1000 records (say)=20 We want only first ten of these records to be returned to the front end=20 & then records 11 to 20 & so on ... =20 How may the above be optimally possible ?=20 SQL or PL/SQL any for it ? =20 Thanks =20 =20 ------_=_NextPart_001_01C35047.81CE4F2C Content-Type: text/html; charset="us-ascii" Content-Transfer-Encoding: quoted-printable

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