OTN Appreciation Day : GeoJSON and SDO_GEOMETRY marriage in Oracle 12.2
The native JSON functionality in Oracle Database version 12.2 has evolved quite a bit since the JSON functions first appeared in Oracle Database version 12.1.0.2. Just one example is JSON_TABLE can be used as a bridge between the open standard GeoJSON format and the database…
Sunday speaking at Oracle OpenWorld 2016
You all know Oracle OpenWorld, right? It’s a behemoth of a conference filling up the streets and hotels of San Francisco with many thousands of people moving like ants between conference rooms, checking out exhibitors, hanging around lounging areas, networking, talking, listening, eating, drinking, learning…
OUGN Spring Conference 2016
I’m back after one of the best ocean voyages ever – the OUGN Spring Conference 2016. That conference is arranged by Oracle User Group Norway and is two days from Thursday before lunch-time to Saturday before lunch-time. The special thing is, that it all happens…
Row pattern matching nested within hierarchy
I’ve been playing around with MATCH_RECOGNIZE – the data pattern matching extension to SELECT that was introduced in version 12. Most examples I’ve seen have used the default AFTER MATCH SKIP PAST LAST ROW as most often the logic dictates, that when we have found…
Vessel Fuel Consumption – or Restarting Running Sum
I got a question recently from Morten Braten whether my FIFO analytic techniques could be helpful for calculating the value of fuel consumption for cargo vessels. It turned out not to be quite the same, but similar. Analytic functions definitely could help. I’ll show how…