Is there any script to identify the OLD and NEW value of a column (last updated), output need in a single row with two different columns with OLD_Value and New_Value like this?
I am using GridDB on the Windows platform.
oracle-grid-control
Is there any script to identify the OLD and NEW value of a column (last updated), output need in a single row with two different columns with OLD_Value and New_Value like this?
I am using GridDB on the Windows platform.
Best Answer
Answered by mustaccio in a comment:
This can only be done while the row is being updated, in a trigger.