I've successfully created a PL-SQL dynamic content report in Oracle Apex, but I'm struggling with implementing pagination. With too many rows to display at once, adding pagination will greatly enhance the user experience. Here is a snippet of my code:
BEGIN
htp.p('<table>
<tr> <th>ID</th>
<th>First Name</th>
<th>Last Name</th>
<th>Email</th></tr>');
for i in(select * from exampleTable)
loop
htp.p('<tr>
<td>'||i.id||'</td>
<td>'||i.first_Name||'</td>
<td>'||i.last_name||'</td>
<td>'||i.email||'</td>
</tr>');
end loop;
htp.p('</table>');
END;