Re: SELECT

From: Uli Herberg <ulrich.herberg_at_lrz.tu-muenchen.de>
Date: Fri, 21 Sep 2001 14:53:08 +0200
Message-ID: <9ofd69$8gk$1@wsc10.lrz-muenchen.de>

> No, it's not strange, it's that I am a bloody idiot:
> from the Oracle documentation:
>
> Conditions testing for ROWNUM values greater than a positive integer are
> always false.
>
> http://technet.oracle.com/doc/server.815/a67779/ch2.htm#33158
>
> So, there is no way to restrict the resultset returned
> from row...to row...

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!!!

Thanks,
Uli Received on Fri Sep 21 2001 - 07:53:08 CDT