Ensure start-end dates sequences are consecutive – i.e. no gaps or overlaps – with primary, unique, and foreign keys

—

Need help with SQL?

Learn SQL in this free course https://devgym.oracle.com/pls/apex/dg/class/databases-for-developers-foundations.html

Ask us over on AskTOM: https://asktom.oracle.com

BlueSky: https://bsky.app/profile/chrisrsaxon.bsky.social
Daily SQL BlueSky tips: https://bsky.app/profile/sqldaily.bsky.social
All Things SQL blog: https://blogs.oracle.com/sql/
Test your SQL Skills on the Oracle Dev Gym: https://devgym.oracle.com/

===========================
The Magic of SQL with Chris Saxon