DECLARE
  seqval NUMBER;
BEGIN
  SELECT NVL(MAX(reservation_id),0)
  INTO seqval
  FROM reservation;

  :NEW.nummer := seqval + 1;
END;