DBAsupport.com Forums - Powered by vBulletin
Results 1 to 2 of 2

Thread: A range of records rom query

  1. #1
    Join Date
    Aug 2000
    Hi all

    I have a query which returns say 200 records, but I want to display only first 20 at the first time, and when user clicks on next I want to display the next 20 records.

    Does anyone have doen this before.
    Thanks in advance.

  2. #2
    Join Date
    Jul 2000


    iam a new entrant to oracle I have a small solution See if that is OK In ur PL/SQL block u need to issue a SQL*PLUS command (say Set Pause On) This is set only when the countof record reaches every 20 records . This can be done using DBMS_SQL package. wherein u have dynamic queries being generated , I believe .See if this is Ok . If u have any solution do post it back.

    Vish M P

Posting Permissions

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

Click Here to Expand Forum to Full Width