Since 12c we have had the cool IDENTITY column feature which removes the tedium of creating sequences, triggers and the like to maintain a simple surrogate column (typically a primary key). SQL> create table t ( x int generated always as identity , y int); Table created. SQL> insert into t (y) values (10); 1 […]