Results 1 to 2 of 2

Thread: Retrieving rows

  1. #1
    Join Date
    Sep 2003
    Posts
    15

    Unanswered: Retrieving rows

    Hi,
    I have 10000 records in a table and i want to retrieve 500 records at a time, and when the user clicks on the next button i want to display the next 500 records. How do i achieve this? I am using oracle 9i.

    Any help would be appreciated

    Thanks

  2. #2
    Join Date
    Oct 2003
    Posts
    2

    Lightbulb Re: Retrieving rows

    hi
    in ur frontend use two variable
    ln_inc:=1
    ln_con:=501;

    select * from
    (select * from emp
    minus
    select * from emp
    where rownum<ln_inc)
    where rownum<ln_con

    for every button press increase ln_inc by 500 (ln_inc:=ln_inc+500)
    i think this will solve ur problem

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •