Merge Always Updates Sequence Number

(Bobby Durrett) This is nothing new, but I wanted to throw out a quick post to document it. If you have a sequence.nextval in the insert part of a merge statement the merge calls nextval for all the updated rows as well.

Register to Read