Using ROWNUM to paginate the data in Oracle
In one of my previous posts, I showed you how to use ROWNUM with ORDER BY clause. Building on that in this post I will show you how you can paginate your results using ROWNUM in Oracle DB and how you should not paginate your data. Suppose I have a table with the following structure: … Read more