jlcox Member³ Aug 16, 2007 #1 Create a sequence Code: create sequence SEQ_TEST minvalue 10 maxvalue 999999999999999999999999999 start with 620 increment by 10 nocache; Use the PL/SQL Developer sequence editor and change the "next number" value to 630 and apply. Value will change to 639.
Create a sequence Code: create sequence SEQ_TEST minvalue 10 maxvalue 999999999999999999999999999 start with 620 increment by 10 nocache; Use the PL/SQL Developer sequence editor and change the "next number" value to 630 and apply. Value will change to 639.