Oracle Database Release 12c (12.1) introduced a new operator that we can use in SQL queries. The MATCH_RECOGNIZE operator allows…
One of those things SQL developers are frequently looking at is the generation of rows: having a query return records…
Below you will find an overview of all the sessions that took place at the AMIS25 Beyond the Horizon conference…
![2018836700[1]](https://i0.wp.com/technology.amis.nl/wp-content/uploads/2015/01/20188367001.jpg?resize=351%2C185&ssl=1 "Parse JSON Array in SQL and PL/SQL – turn to a Nested Table")
Transferring data between technologies and application tiers is done using various formats – binary, native on the one hand and…
note: I would like to thank Mark Rittman of RittmanMead for sharing many of this findings from Oracle OpenWorld 2015…
One of the cool stories of Oracle OpenWorld and JavaOne 2015 is the story of MySQL, in particular of release…
This article gives an overview of some of the most eye catching stories from Oracle OpenWorld 2015 around Data Management.…
Time has always been an important dimension for data in any database with topics like when was data created, when…
Last week I read this blogpost by Scott Wesley. In this post he describes that he uses a custom aggregate…
While writing an article on database session context for the OTech Magazine’s Spring issue, I tried out whether I can…
This article does not necessarily discuss the big themes and major stories of Oracle OpenWorld 2014. It does mention a…
A few days ago, I presented a session at Oracle OpenWorld 2014 about the most useful features for application developers…
Oracle Database 7.3 was the first to support inline views – using the select * from (select * from) syntax.…
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…
Tag clouds are a special way to present information about a set of records. Tags are descriptive labels that are…
As I recently said in another blog post, the World Cup Football is such a wonderful source of data that…
Few things lend itself so well to SQL explorations as sport related data. The imminent World Cup Football (or Soccer…
During the OUGF 2014 Harmony Conference in Finland, I attended a seminar by Chris Date on Temporal Data and the…
I am currently attending the OUGF 2014 Harmony Conference in a beautiful setting on a Finnish lakeside. This conference has…
The speed of cars can be detected at large distance and with great accuracy using laser speed guns. How the…
