Unnamed

CREATE OR REPLACE TRIGGER trg_contract
BEFORE INSERT OR UPDATE of con_begdate ON contract
FOR EACH ROW
BEGIN
  IF :NEW.con_status = 'Open' AND :NEW.con_enddate = NULL
  THEN :NEW.con_enddate := :NEW.con_begdate + 730;
  END IF;
END;
/