0 Oracle OpenWorld 2014: Non-life altering observations (but still interesting and useful)
This article does not necessarily discuss the big themes and major stories of Oracle OpenWorld 2014. It does mention a…
Browsing: sql
0 Everything That Is Really Useful in Oracle Database 12c for Application Developers – Oracle OpenWorld 2014
A few days ago, I presented a session at Oracle OpenWorld 2014 about the most useful features for application developers…
0 SQL: combine inline PL/SQL function with inline view in Oracle Database 12c SQL Query
Oracle Database 7.3 was the first to support inline views – using the select * from (select * from) syntax.…
0 SQL Challenge: Drilling down into World Cup Football Tag Cloud
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…
0 SQL Challenge: Dynamically producing a tag cloud for World Cup Football matches
Tag clouds are a special way to present information about a set of records. Tags are descriptive labels that are…
3 SQL Challenge: Find World Cup Football matches with a comeback
As I recently said in another blog post, the World Cup Football is such a wonderful source of data that…
1 SQL Challenge – World Cup Football 2014 – Retrieving matches and Calculating Group standings
Few things lend itself so well to SQL explorations as sport related data. The imminent World Cup Football (or Soccer…
10 SQL Challenge – packing time intervals and merging valid time periods
During the OUGF 2014 Harmony Conference in Finland, I attended a seminar by Chris Date on Temporal Data and the…
0 Notes from Finland – impressions from the OUGF 2014 Harmony Conference
I am currently attending the OUGF 2014 Harmony Conference in a beautiful setting on a Finnish lakeside. This conference has…
0 SQL Challenge – Calculating the legal maximum speed measured by the laser speed gun
The speed of cars can be detected at large distance and with great accuracy using laser speed guns. How the…
0 SQL based Charts – Scatterplot for x,y coordinate data sets (growth curve, euro/dollar ratio)
Today, against all priorities, I have resumed an old hobby: the creation of charts with nothing but SQL to work…
0 The AMIS Summary of Oracle OpenWorld 2013 is available for download – 60-page white paper
Oracle OpenWorld is a monster event – 10Ks of attendees, thousands of sessions and 100Ks of private conversations that all…
![fibre-optic[1]](/wp-content/uploads/2014/07/fibre-optic1-351x185.jpg "On the integrity of data in Java applications – presentation from JFall 2013")
0 On the integrity of data in Java applications – presentation from JFall 2013
The accuracy, internal quality, and reliability of data is frequently referred to using the term ‘data integrity’. Without it, data…
2 Enriching XMLType data using relational data – XQuery and fn:collection in action
One of my colleagues had an interesting challenge. In an Oracle Database he has a table that contains an XMLType…
2 Java 8 – Collection enhancements leveraging Lambda Expressions – or: How Java emulates SQL
Part of the evolution of Java in release 8 consists of Lambda expressions. These ‘functional expressions treated as variables’ introduce…
0 Oracle Database SQL – Recursive Subquery to inspect events in football matches – find the MVP
In a recent post (https://technology.amis.nl/2013/07/24/oracle-database-12c-find-most-valuable-player-using-match_recognize-in-sql/) I described how we can use the new Oracle Database 12c MATCH_RECOGNIZE operator to spot…
3 Oracle Database 12c: Find most valuable player using MATCH_RECOGNIZE in SQL
One of the very nice new features in SQL in Oracle Database 12c is the MATCH_RECOGNIZE operator. MATCH_RECOGNIZE adds a…
8 Oracle Database 12c: quickly create a virtual machine with OEL 6.4 and Oracle Database 12c (for dummies)
I am first and foremost a developer. I am not an administrator. I know more about IDEs and GUIs than…
0 Oracle Database 12c: Pattern Matching through MATCH_RECOGNIZE in SQL
Oracle 8i (8.1.6 if I remember correctly) started with the introduction of a that wonderful new phenomenon in SQL: Analytical…
0 Oracle Database 12c: joining and outer joining with collections
Joining is a key ingredient in most SQL queries. Using collections (aka nested tables) that are produced on the fly…