Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Best Way for Recordset Paging
I have read several techniques outlined in this group for recordset paging:
Has anyone used the second technique - using triggers to returned a page from a recordset ? I'm looking for real life experience out there since I find using a temp table very slow with a large amount of records, and the overhead of creating and destroying the temp table to be too much.
I also can't use where rownum <= X and rownum >= y since it does not order the query first before assigning the rownum.
Any suggestions on a better approach, or how to use triggers to perform recordset paging ?
Thanks. Received on Sat Jun 16 2001 - 00:15:19 CDT