how to reset sequences in oracle
the best approach to reset a sequence in oracle.
SELECT * FROM user_sequences
CREATE SEQUENCE demo_seq MINVALUE 0 INCREMENT BY 1 NOCACHE
DROP SEQUENCE demo_seq
DECLARE
VALUE NUMBER;
BEGIN
FOR rec IN 1..1000 LOOP
VALUE := demo_seq.nextval;
END LOOP;
END;
SELECT demo_seq.nextval FROM dual
ALTER SEQUENCE demo_seq INCREMENT BY -1009