How to get gap free sequence numbers
The first rule of gap free sequences is .... just forget about it and allow gaps :-)
But if for some reason that is not an option, here is a relatively scalable mechanism using some of the features designed for Advanced Queuing to allow sequence number allocation which is gap free but has a couple of compromises.
Follow me!
blog: https://connor-mcdonald.com
twitter: / connor_mc_d
The Podcast!
https://podcasts.apple.com/au/podcast...
https://open.spotify.com/show/5dqVVft...
Subscribe for new tech videos every week
Other social media channels here: https://linktr.ee/connor
A free Oracle database forever ?! Oh yes indeed!
https://www.oracle.com/cloud/free
Music: Night Owl (Broke For Free), Kevin Mcleod (incomptech), Dyalla
#oracle #sequences #performance
Watch video How to get gap free sequence numbers online without registration, duration hours minute second in high quality. This video was added by user SQL and Database explained! 31 March 2022, don't forget to share it with your friends and acquaintances, it has been viewed on our site 1,642 once and liked it 57 people.