Life, The Universe and Oracle Specifically ORDS, APEX, REST and PL/SQL
Quite some time ago I was asked by a customer how we could track the changes to a row over time. They had a couple of very important tables for which they wanted to keep track of who changed what. The interesting thing was that they were not interest...
There are many times when you're coding an application where there is a requirement for seed data that is required for the system to run correctly. If the seed data is changed or missing, some programming functions will fail due to the missing data. ...
This article was first published on blogs.oracle.com in September of 2019. Not long after it was published I was made aware of a couple of security flaws. However by that time the underlying blogging platform Oracle was using had been migrated and I ...
In honor of #JoelKallmanDay, I thought I’d break back into blogging after a long hiatus with an update on some of my more popular posts of the past – Oracle APEX and Workflow. In January of 2018, I kicked off a little personal research project. The g...
After my initial post about this, I had a discussion with John Snyders of HardLikeSoftware fame, and it turns out there is a better and more efficient way to maintain the tree state. While what I outlined definitely works, what follows is the “prefer...
As soon as I was finished with the first incarnation of the ORDS REST Workshop for release in APEX 18.1, I had a list as long as my arm of things that I wanted to do to improve it. Some small, some large. One of the things that bugs me the most is th...
Although I’ve been quiet as of late with regard to my “All-The-Things” workflow project, that doesn’t mean I’ve been sitting idle. No, in fact I’ve been running in circles at quite an alarming rate. My last related post mentioned that I was ordering ...
Remember when I said that, for my All The Things project, “My goal is to go through the steps I would normally traverse when building an application for a paying client”? Well one of those steps would surely be to understand what was already availabl...
In my previous post I mentioned that I’d be developing a non-trivial, real-world application from scratch and approach it in the same way I would if I were doing it for a paying client. The first step in that direction is to gather requirements and d...