Select Code to Download

  -- :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;