Skip to Main Content
Forums

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!

insert all - sequence number skips between the table

User_6GLH0Mar 22 2021 — edited Mar 22 2021

Hi All,
I am using insert all to load two tables and I need to use same sequence number in both tables. However, I see the sequence numbers are different for both tables.
For example:
Table A - I see sequence number 1, 3, 5, 7
and
Table B - I see sequence number 2, 4, 6, 8
Can someone please let me know how can I use the same sequence for both table loads using insert all ?

Thank you
This post has been answered by Frank Kulash on Mar 22 2021
Jump to Answer
Comments
Post Details
Added on Mar 22 2021
4 comments
391 views