Re: Next Pages!!!!!??????

You can do the following:

1st 25 rows
Select C1, C2, Cn
From Table Where ROWNUM <= 25

rows 26 ->50
Select C1, C2, Cn
From Table
Where ROWNUM > 25 AND

            ROWNUM <=50

The "<=" is used since we're not sure what the last ROWNUM value is. The actual rows retrieved by this method can vary if the underlying table isn't static.

Mike Rose

Chenping Tsou wrote in message <36E5C2E9.B798E4AB_at_iii.org.tw>...
>Is there a way that I could fetch the first 25 records of a infinite
>sized table, then issue a command to fetch the next 25 records through
>SQL command?
>Basically I want to display data usgin Java Servlet to a browser
>interface. The first procedure
>would be to get the first 25 records, then if the user pressed next
>page, it will display the next 25 records. I don't want to load the
>whole table as this would be very time consuming. I only want to load
>the records that I am displaying.
>
>Thanks, Ping.
>
Received on Wed Mar 10 1999 - 00:00:00 CET