In a previous article, I have introduced the World Cup Football tag cloud (https://technology.amis.nl/2014/06/22/sql-challenge-dynamically-producing-a-tag-cloud-for-world-cup-football-matches/). I have shown how tags can…
Joining is a key ingredient in most SQL queries. Using collections (aka nested tables) that are produced on the fly…
This presentation will hopefully convince database developers that types in the Oracle Database are worth their salt – and more.…
It happens quite frequently that in our database applications – in queries or in PL/SQL packages – we need to…
![2018836700[1]](https://i0.wp.com/technology.amis.nl/wp-content/uploads/2015/01/20188367001.jpg?resize=351%2C185&ssl=1 "Extreme Decoupling in SQL – Select and DML against a table that is not a table at all")
One of the key objectives – though not ulterior motives – in Service Oriented Architecture is decoupling. By decoupling currently…
Another world shattering topic: analyzing tag clouds. This article describes a very simple first step for some analysis at database…
In a previous article – Not all has to be black and white in SQL Queries – , I discuss…
One very efficient way of passing data from the Java application to the database is through the use of custom…
While preparing for a whole different topic, I had to create a few demonstrations of using custom SQL Types and…
