SQL> create sequence seq; Sequence created. SQL> select seq.nextval from dual; NEXTVAL ----- 1 SQL> select seq.nextval from dual; NEXTVAL ----- 2 SQL> select seq.nextval from dual; NEXTVAL ----- 3 ...
My table is as follows: I have a candidate key using columns A-E. This is too many, but column A is very helpful to keep in each table that references it, so I want to generate a surrogate key using ...