Possible to insert more than once into same table using multi table insert?
361137Jul 29 2011 — edited Jul 29 2011I have used multi-table insert before to insert from one source into multiple separate tables no problem.
However when I want to insert into the same table two or more distinct rows I encountered an issue because when I call nextval on the sequence since it is the same sequence # its going to try to use the same number for both the inserts, which will throw a PK constraint violation on the 2nd insert.
Any way to get around this?