Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.misc -> Re: get x number of records from the table

Re: get x number of records from the table

From: Chris Rodrigues <cr148_at_yahoo.com>
Date: 12 Sep 2001 16:46:51 -0700
Message-ID: <e1fa2ab9.0109121546.25cac09e@posting.google.com>


"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

If you are using JDBC, use the resultset option to control display of results. Received on Wed Sep 12 2001 - 18:46:51 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US