Re: get x number of records from the table
From: Vladimir Ivanovich <vladimiri_at_bosmedtech.com>
Date: Wed, 12 Sep 2001 17:19:29 -0400
Message-ID: <SM2o7.2$2f1.15154_at_news.nyc.globix.net>
Date: Wed, 12 Sep 2001 17:19:29 -0400
Message-ID: <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
>
>
Received on Wed Sep 12 2001 - 23:19:29 CEST