Create sequence seq1 start with 100 increment by 10 maxvalue 200 cycle nocache select seq1.nextval from dual;