Hi All,
I used below script to create sequnce and reset(ALTER SEQUENCE) sequence value. Is there any way to get this history/log.
CREATE SEQUENCE test_seq
MINVALUE 0
MAXVALUE 999999999999999999
INCREMENT BY 1
NOCACHE
NOCYCLE;
SELECT TEST_SEQ.NEXTVAL FROM DUAL;
DECLARE
V_VALUE NUMBER;
BEGIN
FOR i in 1..10 LOOP
V_VALUE := TEST_SEQ.NEXTVAL;
END LOOP;
END;
ALTER SEQUENCE TEST_SEQ INCREMENT BY -10;
SELECT TEST_SEQ.NEXTVAL FROM DUAL;
ALTER SEQUENCE TEST_SEQ INCREMENT BY 1;
SELECT TEST_SEQ.NEXTVAL FROM DUAL;
I am using Oracle 19c .
Thanks in advance.
Best Regards,
Abu