Re: SELECT

From: Davide Bianchi <davidebianchi_at_davidebianchi.net>
Date: Fri, 21 Sep 2001 14:57:05 +0200
Message-ID: <9ofdhh$cossg$1@ID-18487.news.dfncis.de>

"Uli Herberg" <ulrich.herberg_at_lrz.tu-muenchen.de> wrote in message news:9ofd69$8gk$1_at_wsc10.lrz-muenchen.de...
> Isn't there any workaround?
> I'm writing a java servlet which displays the
> entries to the user. The user should always see
> 30 entries and then be able to see the switch to
> the next 30 entries. I don't want to display 10000
> entries in one page!!!

If your table/view have an Unique ID (should do) you can store the last ID displayed and then use that as a starting point to restrict your query...

SELECT ... FROM ... WHERE ID_FIELD >= ... AND ROWNUM <= 30

Davide Received on Fri Sep 21 2001 - 07:57:05 CDT