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!

recycle sequence value

xarg-XrcNov 20 2012 — edited Nov 20 2012

Hi,

Just a question on how sequences work. If its used for primary key and I delete a row (say ID: 1058), would a sequence generate 1058 again? Or would it just continue upwards till MAXVALUE?

Thanks,

Using 11G R2 in linux

This post has been answered by unknown-7404 on Nov 20 2012

Jump to Answer

Locked Post

New comments cannot be posted to this locked post.

Locked on Dec 18 2012

Added on Nov 20 2012

#general-database-discussions

4 comments

1,064 views