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
Printable View
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