@DougAGault

Auditing Data Change History

Jan 4, 2023 · 4 min read · 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...

A quick seed data merge script generator

Dec 22, 2022 · 4 min read · 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. ...

DLDShyam and 2 more commented

3

Custom Authorization using built-in APEX Access Control - A How To

Nov 29, 2022 · 19 min read · 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 ...

Oracle APEX & Workflow - Problem Solved?

Oct 11, 2021 · 4 min read · 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...

Maintaining APEX Tree Region Expansion State: UPDATED!

Oct 25, 2018 · 4 min read · 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...