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 […]
Using BULK COLLECT INTO construct in Oracle PLSQL
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 […]
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 […]
