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… Read More ›
SQL
Using BULK COLLECT INTO construct in Oracle PLSQL
At times when you are programming in PLSQL you would want to fetch multiple records into an ARRAY or some collection. One approach to do is to loop through the result of the SQL query and then keep adding each… Read More ›
Using ROWNUM with ORDER BY in Oracle SQL
Lot of times you have tried to use ROWNUM clause along along with the ORDER BY clause and must have been treated with a different output than you expected. You would expect the ROWNUM to be applied after the results… Read More ›
MySQL: World’s Most popular Open Source database
What is MySQL? MySQL is an Open Source database management system(DBMS) that one can download for free from MySQL Website (www.mysql.com). MySQL is one of the world’s most popular systems for Java web applications because of its consistent fast performance, high… Read More ›