Re: scrolling through tables

From: Nuno Guerreiro <nuno-v-guerreiro_at_telecom.pt>
Date: Wed, 13 May 1998 11:39:50 GMT
Message-ID: <35598644.179495040@news.telecom.pt>

On Wed, 13 May 1998 12:19:58 +0200, "Herbert" <herbs_at_worldonline.nl> wrote:

>While building an application i am experiencing the following problem:
>
>I want to select an 'window' from a selection from a table, in order to
>scroll through a table with increments of say 10 records at a time. A very
>simplistic view to this problem is:
>
>select * from table where rownum >10 and rownum < 20;
>
>this however won't work according to the oracle docs.
>
>Anyone got a suggestion?
>
>herbert_at_veronica.nl
>
>

You can declare a cursor and select the amount of records you need, perform some action and then select the next record set.

Hope this helps,

Nuno Guerreiro Received on Wed May 13 1998 - 06:39:50 CDT