Learning is not a spectator sport

I wrote a post a few years back (well, actually it was 2018!) but I’ll paraphrase briefly. There are two common schools of thought when it comes to automatic generation of values for a surrogate key in the Oracle database. The first one is using a SEQUENCE, referencing it either directly in your table definition/SQL,…