I want to keep a history of changes on a field in a table. This will be
the case in multiple tables.
Can I create a trigger that loops the OLD and NEW values and compares
the values and if they are different creates a change string as follows:
e.g;
FOR EACH field IN NEW
IF field.value <> OLD.field.name THEN
changes := changes
|| field.name
|| ' was: '
|| OLD.field.value
|| ' now is: '
|| field.value
|| '\n\r';
END IF
END FOR;
Your help is really appreciated.
Thank you.