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.

Reply via email to