I won't link to the old OTech Magazine url - that domain has now been taken over by someone definitely not writing Oracle related material... So any links I may have sent out to OTech Magazine articles are not working anymore.
Instead I sent the DOUG member a PDF with my article. And later I thought, well, there might be others out there that could benefit from that article as well as the others I wrote. So this blog post is simply an archive of links to my OTech Mag articles as PDFs - not necessarily quite the same format as they were released in OTech Mag at publication time, but the same content.
So without further ado, here's my OTech Mag article archive list:
- OTech Mag Spring 2014:
Analytic Warehouse Picking
My old and tried methods of FIFO picking in a single SQL with analytic function.
- OTech Mag Summer 2014:
External Data from Within
Calling out from the database using FTP, HTTP(S) and webservices to retrieve data.
- OTech Mag Winter 2014:
Time Series Forecasting in SQL
Sales forecasting doing a simple time series model all in SQL using REGR_SLOPE.
- OTech Mag Spring 2015
Forecasting with R and SQL
Sales forecasting using R forecast package and ROracle driver to get at the data.
- OTech Mag Winter 2015
Hierarchical count with MATCH_RECOGNIZE
A use case for a little used option in the MATCH_RECOGNIZE clause.
I hope maybe other OTech Mag article writers can put an archive of their articles somewhere, as there was a lot of great content in OTech Mag.
At least I hope my articles can useful to someone :-)