I learned an important lesson over the last few days. You all probably know this already, but as you may also know I am generally not reticent to expose my relative ignorance. So I follow a standard of adding four audit columns to my tables, populated by triggers, which keep track of who inserted/updated the row, and when: I certainly did this for the qdb_users table, which is the users table for the PL/SQL Challenge and Oracle Dev Gym. So far, so good. But recently a player complained that she was not receiving emails with results of her quizzes. I checked and found that the preference was turned off. Had she modified her user profile lately or had my code done something to her row? It was pretty much impossible to tell, because we keep track of the user's last visit to the site - which means the app itself updates the qdb_users.changed_by/on columns every time a user comes to the site. This would overwrite whatever the user's last changed_on value was....
For the last twenty years, I have managed to transform an obsession with PL/SQL into a paying job. How cool is that?