| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
 |
 | |||
| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
|
| |||
Home -> Community -> Mailing Lists -> Oracle-L -> 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
<html>
<head>
<meta http-equiv=3DContent-Type content=3D"text/html; =
charset=3Dus-ascii">
<meta name=3DGenerator content=3D"Microsoft Word 10 (filtered)">
<style>
<!--
/* Style Definitions */
p.MsoNormal, li.MsoNormal, div.MsoNormal
{margin:0in;
margin-bottom:.0001pt;
font-size:12.0pt;
font-family:"Times New Roman";}
a:link, span.MsoHyperlink
{color:blue;
text-decoration:underline;}
a:visited, span.MsoHyperlinkFollowed
{color:purple;
text-decoration:underline;}
span.EmailStyle17
{font-family:Arial;
color:windowtext;}
span.EmailStyle18
{font-family:Arial;
color:navy;}
@page Section1
{size:8.5in 11.0in;
margin:1.0in 1.25in 1.0in 1.25in;}
div.Section1
{page:Section1;}
</head>
<body lang=3DEN-US link=3Dblue vlink=3Dpurple>
<div class=3DSection1>
<p class=3DMsoNormal><font size=3D2 color=3Dred face=3DArial><span =
style=3D'font-size:
10.0pt;font-family:Arial;color:red'>CASE </span></font></p>
<p class=3DMsoNormal><font size=3D2 color=3Dred face=3DArial><span =
style=3D'font-size:
10.0pt;font-family:Arial;color:red'> </span></font></p>
<p class=3DMsoNormal><font size=3D2 color=3Dred face=3DArial><span =
style=3D'font-size:
10.0pt;font-family:Arial;color:red'>select * from table gives 1000
records (say) </span></font></p>
<p class=3DMsoNormal><font size=3D2 color=3Dred face=3DArial><span =
style=3D'font-size:
10.0pt;font-family:Arial;color:red'>We want only first ten of these =
records to
be returned to the front end </span></font></p>
<p class=3DMsoNormal><font size=3D2 color=3Dred face=3DArial><span =
style=3D'font-size:
10.0pt;font-family:Arial;color:red'>& then records 11 to 20 & so =
on …</span></font></p>
<p class=3DMsoNormal><font size=3D2 color=3Dred face=3DArial><span =
style=3D'font-size:
10.0pt;font-family:Arial;color:red'> </span></font></p>
<p class=3DMsoNormal><font size=3D2 color=3Dred face=3DArial><span =
style=3D'font-size:
10.0pt;font-family:Arial;color:red'>How may the above be optimally =
possible ? </span></font></p>
<p class=3DMsoNormal><font size=3D2 color=3Dred face=3DArial><span =
style=3D'font-size:
10.0pt;font-family:Arial;color:red'>SQL or PL/SQL any for it =
?</span></font></p>
<p class=3DMsoNormal><font size=3D2 color=3Dred face=3DArial><span =
style=3D'font-size:
10.0pt;font-family:Arial;color:red'> </span></font></p>
<p class=3DMsoNormal><font size=3D2 color=3Dred face=3DArial><span =
style=3D'font-size:
10.0pt;font-family:Arial;color:red'>Thanks</span></font></p>
<p class=3DMsoNormal><font size=3D2 color=3Dred face=3DArial><span =
style=3D'font-size:
10.0pt;font-family:Arial;color:red'> </span></font></p>
<p class=3DMsoNormal><font size=3D3 color=3Dred face=3D"Times New =
Roman"><span
style=3D'font-size:12.0pt;color:red'> </span></font></p>
</div>
Received on Tue Jul 22 2003 - 06:50:54 CDT
 |
 |