Why a Sequence gives duplicate values!

Published: 03 December 2020
on channel: SQL and Database explained!
836
53

It is common knowledge that every time you request the next value from a sequence, you get a new number. That is the entire purpose of sequences ... no duplicates! But there is a special case you need to be aware of, where you might get duplicate key violations even though you are populating that unique key with a call to SEQUENCE.NEXTVAL.....


blog: https://connor-mcdonald.com
twitter:   / connor_mc_d  

Subscribe for new tech videos every week

All other social media channels here: https://linktr.ee/connor


Are you serious? A free Oracle database forever ?!?!?!?! Hell yeah!!!

https://www.oracle.com/cloud/free


Music: Night Owl (Broke For Free)
, Dyalla

#oracle #sequence #insert