[Closed] STW vs Google - Changing an Oracle sequence number

I don't understand the question

I do think this website might help though
http://www.lmgtfy.com/?q=Oracle+sequence+numbers

We have created a sequnce number like :

CREATE SEQUENCE <sequence_name>
INCREMENT BY <integer>
START WITH <integer>
MAXVALUE <integer> / NOMAXVALUE
MINVALUE <integer> / NOMINVALUE
CYCLE / NOCYCLE
CACHE <#> / NOCACHE
ORDER / NOORDER;

but whoever did it started it at 1 when we need it to start at 50,000. We don't really want to drop and recreate it and was wondering if there was some way to reset the current value to be 50,000 and then let it continue incrementing by 1

Cheeky bast@rd link. 😉

Google wins

The jet is what you just said... 😯

alter the sequence
increment it by xxxxxx

select sequence_name.nextval from dual;

alter the sequence
increment it by 1.

job done.

incidently if you want it to start at 50,000 you might want to set the sequence to ORDER.

Fuzzy Wuzzy was a woman?

In Toad:

select sequence_name.nextval from dual;

And jam a bit of paper in the F9 key?

In Toad:

select sequence_name.nextval from dual;

And jam a bit of paper in the F9 key?

LOL 😀