SQL & PL/SQL

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Merge statement is incrementing sequence. Will it cause any problems???

inDiscoverJun 17 2014 — edited Jun 17 2014

Hi All,

I am using a merge statement to update thousands of data in a table. If the criteria is not matching (WHEN NOT MATCHED) I have written an insert statement which contains a reference to sequence. And it is working fine.

My question is, will this increment sequence also even though it is not going to insert statement inside the merge script. I think it will. Right????

Say, I am updating 20K records will the sequence also increment by 20k times. If its happening any work around.

Thanks in advance.

This post has been answered by Moazzam on Jun 17 2014

Jump to Answer

Locked Post

New comments cannot be posted to this locked post.

Locked on Jul 15 2014

Added on Jun 17 2014

14 comments

2,061 views