I haven’t had to do much with Oracle for a while and totally forgot how to create the next “autonumber” or “sequence” for a table’s ID key. So here’s a reminder.

into PERSON (CREATEDDATE, ID, ...) 
values (SYSDATE, PERSON_seq.NEXTVAL, ...)

Sequence Pseudocolumns