How can i get a field’s old value from Update Notification Trigger incase i modify the key field.
For eg, if i do an update on the table, like
Update set key_field=value1 where key_field=value2.
When Update Trigger is triggered, i can get value1, but how can i get the old value2 from Trigger operation.
your suggestions are appreciated.