A handful of articles
A little while ago a member of the Danish Oracle User Group DOUG asked if anyone had a bit of experience with use of R together with Oracle Database. I remembered an article I wrote for OTech Magazine on forecasting with R and Oracle and thought…
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…