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: https://twitter.com/connor_mc_d The Podcast! https://podcasts.apple.com/au/podcast/the-spoken-nerd/id1552316025 https://open.spotify.com/show/5dqVVftZhw0lu1fnX20TiP 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