Skip to content

new sequence

CREATE SEQUENCE ADMIN.WM_REC_ID_SEQ
  START WITH 00000001
  MAXVALUE 99999999
  MINVALUE 00000001
  NOCYCLE
  CACHE 20
  NOORDER;

select all oracle sequence

SELECT * FROM user_sequences;

auto max value

MAXVALUE 999999999999999999999999999

update sequence

ALTER SEQUENCE seq_name
INCREMENT BY 124;

SELECT seq_name.nextval FROM dual;

ALTER SEQUENCE BANK_SEQ
INCREMENT BY 1;