Re: using pl/sql to step through a cursor 'x' rows at a time on a web page

Hi Ian

I do this in SQL
here is my code

SELECT your_fields
  FROM (SELECT ROWNUM

• 1 therow, your_fields FROM (SELECT your_fields FROM your_table ORDER BY your_order)) WHERE TRUNC (therow / :record_per_page) + 1 = :page_number

hth

Chris

ian_at_ficklings.com (Ian Fickling) wrote in message news:<1a35d6db.0112022032.5e6735aa_at_posting.google.com>...
> Whats the best way to do the following :-
>
> Suppose a query returns 500 rows. I want to present a web page (via
> pl/sql tool kit - oracle 817) that can step through the rows say 50 at
> a time.
>
> Ie
> Using pl/sql in a stateless web page I want to have a page what
> displays the first 50 rows and has a 'next' button. The user can click
> next and the next 50 rows are displayed.
>
> Anyone have an exmaple of this?
>
> Thanks
> Ian
Received on Tue Dec 04 2001 - 22:39:40 CET