create sequence ZCMD_SEQ_TEST 
minvalue 90000000 
maxvalue 100000000 
start with 94683461 
increment by 1 
cache 20

DECLARE 
newnu NUMBER := 1000000001; 
lnu NUMBER; 
ib NUMBER; 
BEGIN 
SELECT last_number, increment_by 
INTO lnu, ib 
FROM all_sequences 
WHERE sequence_name = 'ZCMD_SEQ_TEST'; 
EXECUTE IMMEDIATE 'ALTER SEQUENCE ZCMD_SEQ_TEST MAXVALUE 4999999999'; 
EXECUTE IMMEDIATE 'ALTER SEQUENCE ZCMD_SEQ_TEST INCREMENT BY ' || (newnu - lnu); 
EXECUTE IMMEDIATE 'SELECT ZCMD_SEQ_TEST.NEXTVAL FROM DUAL' INTO lnu; 
EXECUTE IMMEDIATE 'ALTER SEQUENCE ZCMD_SEQ_TEST INCREMENT BY ' || ib; 
EXECUTE IMMEDIATE 'ALTER SEQUENCE ZCMD_SEQ_TEST MINVALUE 1000000000'; 
END;