Oracle recordset paging

I have read several techniques outlined in this group for recordset paging:

1. Using a temp table and identity column - insert ordered rows and return the appropriate rows
2. Using triggers.

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:17:22 CDT