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;