"Sequence Generator" (hereinafter referred to as "Sequence") is a database feature introduced in SQL 2003 Standard. It is defined as "a mechanism for generating successive exact numeric values, one at ...

mgartner commented Jan 21, 2022 Thanks for the report! We do indeed evaluate nextval twice when executing CREATE TABLE mosquito_tb1 AS (SELECT nextval ('mosquito_t1')). This seems incorrect. That ...

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 ...