DBAsupport.com Forums - Powered by vBulletin
Results 1 to 2 of 2
  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

We have made updates to our Privacy Policy to reflect the implementation of the General Data Protection Regulation.