Oracle - Sync Sequence nextval using CONNECT - side effects?
CONNECT in this context has nothing to do with database connections.

hierarchical_query_clause ::=



You can change the increment of a sequence to set it to a required value. Example:

SQL&gt; create sequence s1;

Sequence created.

SQL&gt; select s1.nextval from dual;

   NEXTVAL
----------
         1

SQL&gt; alter sequence s1 increment by 100;

Sequence altered.

SQL&gt; select s1.nextval from dual;

   NEXTVAL
----------
       101

SQL&gt; alter sequence s1 increment by 1;

Sequence altered.

SQL&gt; select s1.nextval from dual;

   NEXTVAL
----------
       102


You can also use the undocumented RESTART clause, but that does not work in 11.2:

SQL*Plus: Release 19.0.0.0.0 - Production on Tue Apr 30 12:44:26 2019
Version 19.3.0.0.0

Copyright (c) 1982, 2019, Oracle.  All rights reserved.


Connected to:
Oracle Database 19c Enterprise Edition Release 19.0.0.0.0 - Production
Version 19.3.0.0.0

SQL&gt; create sequence s1;

Sequence created.

SQL&gt; select s1.nextval from dual;

   NEXTVAL
----------
         1

SQL&gt; alter sequence s1 restart start with 101;

Sequence altered.

SQL&gt; select s1.nextval from dual;

   NEXTVAL
----------
       101

SQL&gt; select s1.nextval from dual;

   NEXTVAL
----------
       102