I need to implement custome paging so that I could handle larger dataset. I saw many articles for that but all of them talking about ROW_NUMBER() OVER() which is not available in oracle.
I am using
- Asp.Net and oracle db.
- using in-line queries rather store procedure.
How can I apply custome paging to address larger dataset ?
Looking forward to hearing from you.