Results 1 to 2 of 2
  1. #1
    Join Date
    Apr 2003

    Question Unanswered: Returning small managable sets from a SELECT statement

    I have a Database that contains 10,000 records. I execute a SELECT statement that returns 8000. I need those 8000 and cannot refine my statement to return a smaller subset.

    My problem is I don't want all the results back in one go. I would like to return to 1000 rows on my first call. On my second call I would like another 1000 rows starting from the end of the last call and so on...

    Is this possible? Also the table has no unique key either, and that ain't gonna change.

    Any suggestions. I would like to implement this in SQL.

    Thanks in advance to anyone who comes up with a good solution

  2. #2
    Join Date
    Jul 2001

    You can use cursor in PL/SQL


    you can use PL/SQL to open a cursor an fetch the records block wise ..


    OPEN, FETCH and CLOSE statements to create a package and use this in your application.

    Hope that hint helps ?

    Manfred Peter
    (Alligator Company GmbH)

Posting Permissions

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