Oracle Database Discussions

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!

Can Sequence.NextVal fill the gaps?

391517Apr 2 2003 — edited Apr 3 2003

If a table is sparse, holding sequence number 1-100, and then 10,000 -- 20,000 for example. Can the sequence number generator fill the gap, meaning to generate number 101 -- 9999, and then pick it up from 20,001 and keep going?

Locked Post

New comments cannot be posted to this locked post.

Locked on May 1 2003

Added on Apr 2 2003

#general-database-discussions

7 comments

591 views