BEGIN
  INSERT INTO mytab (id, ...) VALUES (id_value, ...);
EXCEPTION
WHEN DUP_VAL THEN
  UPDATE mytab
  SET .. = ...
  WHERE id=id_value;
END;