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
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...Received on Thu Sep 13 2001 - 09:20:38 CDT
> 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
> >
> >
>
>