Re: Sequence Skipping
- From: rjamya <rjamya@xxxxxxxxx>
- To: kennethnaim@xxxxxxxxx
- Date: Wed, 13 Jun 2012 16:37:07 -0400
http://docs.oracle.com/cd/B19306_01/server.102/b14200/pseudocolumns002.htm#sthref809
Oracle says so ...
"For each row merged by a MERGE statement. The reference to NEXTVAL can
appear in the merge_insert_clause or the merge_update_clause or both. The
NEXTVALUE value is incremented for each row updated and for each row
inserted, even if the sequence number is not actually used in the update or
insert operation. If NEXTVAL is specified more than once in any of these
locations, then the sequence is incremented once for each row and returns
the same value for all occurrences of NEXTVAL for that row."
--
//www.freelists.org/webpage/oracle-l
Other related posts:
