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 ›
SQL
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 ›
