Function to check if value changed? (in trigger)
Hi!
I'm sure this is FAQ but I couldn't find an answers.
I am looking for a way to compare two values for equality , but also accounting for NULL as being same.
I need this for a trigger, where I would check if the new value is the same as old (or both null) to avoid some costly operations in such case.
Of course I cold write :OLD.column = :NEW.column or :OLD.column is null and :NEW.column is null,
but there must be a shorter way.
Or must I just write an own function? Polymorphic? (NUMBERs , VARCHAR2s, DATEs)
Regards,
David