Re: SELECT

From: Ed Prochak <edprochak_at_magicinterface.com>
Date: Mon, 24 Sep 2001 04:14:15 GMT
Message-ID: <3BAEDDE9.EF1CF93C@magicinterface.com>

Then you should be using a cursor, fetching 30 rows at a time.

For performance you may end up passing some hints to the ORACLE Optimizer. But group fetches are really what you are after.

Good luck.

Uli Herberg wrote:
>
> > 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

Ed Prochak
Magic Interface, Ltd
440-498-3700
magic_at_magicinterface.com Received on Sun Sep 23 2001 - 23:14:15 CDT