-- :NEW.XXXX refers to the value of the XXXX field specified in the update statement -- :OLD.XXXX refers to the value in the record being updated IF :NEW.foo IS NULL THEN :NEW.foo := :OLD.foo END IF;