-
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.
NM
-
Hi
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.
Bye
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
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|