Oracle 12.1.0.2 on Win 64 non-container
When a record in a table is inserted or updated, what would be the best way to store the SCN for that record in that record.
I thought about an after row trigger, but didn't know if that trigger fire to store the current_scn would yet fire off that trigger again (recursive trigger).
Does anyone have a good idea of what the best way is to do this? The devs do not want to store the pk and scn in yet another table...