Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.misc -> Re: get x number of records from the table
Niall Litchfield wrote:
>
> That will only show the first 30 records. There will be no second page.
>
> --
> Niall Litchfield
> Oracle DBA
> Audit Commission UK
> "Vladimir Ivanovich" <vladimiri_at_bosmedtech.com> wrote in message
> news:SM2o7.2$2f1.15154_at_news.nyc.globix.net...
> > Try
> >
> > SELECT *
> > FROM table
> > WHERE rownum <=30;
> > etc.
> >
> > HTH,
> > Vladimir
> >
> > "Rafia Tapia" <rafiat_at_bellatlantic.net> wrote in message
> > news:LiLn7.7152$tL2.661683_at_news1.rdc1.nj.home.com...
> > > Hi
> > > I have the following problem and any help will be appreciated. I am
> > writing
> > > an asp application with oracle 8.0 as the backend. I have a table
> > > with million records. now i have to show 30 records per page. in other
> > words
> > > the first web page shows the record form 1-30 then when the user clicks
> > next
> > > the second page shows 31-60 records and so on. My question is how do i
> > tell
> > > the oracle to send me the first 30 records or the 30-60 records and so
> > forth
> > >
> > > Rafia
> > >
> > >
> >
> >
Looking something called INLINE View technique.
C chang Received on Thu Sep 27 2001 - 18:15:42 CDT