CREATE TRIGGER on_delete_set_null_proj
  AFTER DELETE ON EMPLOYE
  REFERENCING OLD AS emp_efface
  FOR EACH ROW
BEGIN
  UPDATE PROJET
    SET ID_CHEF_PROJET = NULL
    WHERE ID_CHEF_PROJET = :emp_efface.ID_EMPLOYE
END;
/