Oracle - How increment a sequence
2 way ::
1) by changing the increment value
select <Sequence_Name>.nextval from dual;
Example
select SEQ_ABONNEMENT.nextval from dual;
The sequence is incremented by 1 unit.
Pour avancer un sequenceur :
Modifier la valeur increment du sequenceur
alter sequence SEQ_ABONNEMENT increment by <integer>;
Exemple
alter sequence SEQ_ABONNEMENT increment by 10;
2) by looping an increment
To obtain a sequence of the next 10 values, use the CONNECT BY levelclause, as shown:
SELECT catalog_seq.NEXTVAL FROM dual CONNECT BY level <= 10;
The next 10 values get output:
source : https://blog.toadworld.com/oracle-create-sequence-explained-with-examples