ALTER TABLE EMPLOYE ADD (TOTAL_INTERVENTIONS INTEGER DEFAULT 0);

CREATE OR REPLACE TRIGGER NUMBER_inter
AFTER INSERT ON INTERVENANTS
FOR EACH ROW

BEGIN

  UPDATE EMPLOYE E
  SET TOTAL_INTERVENTIONS = TOTAL_INTERVENTIONS + 1
  WHERE E.numEmploye = :NEW.numEmploye ;

END;
/