En este artículo te enseñamos una manera sencilla de reiniciar una secuencia (SEQ) en Oracle.
CREATE SEQUENCE SEQ;
SELECT SEQ.CURRVAL FROM DUAL;
ALTER SEQUENCE SEQ INCREMENT by -VAL;
SELECT SEQ.NEXTVAL FROM DUAL;
ALTER SEQUENCE SEQ INCREMENT by 1;
SQL> create sequence seq; Secuencia creada. SQL> select seq.nextval from dual; NEXTVAL ---------- 1 SQL> select seq.nextval from dual; NEXTVAL ---------- 2 SQL> select seq.nextval from dual; NEXTVAL ---------- 3 SQL> select seq.currval from dual; CURRVAL ---------- 3 SQL> alter sequence seq increment by -2; // 2=SEQ.CURRVAL-1 Secuencia modificada. SQL> select seq.nextval from dual; NEXTVAL ---------- 1 SQL> alter sequence seq increment by 1; Secuencia modificada.