SQL & PL/SQL

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Alter a sequence to set LAST_NUMBER

ANGSHUMAN86Oct 7 2013 — edited Oct 7 2013

Suppose I have a sequence like below

SEQUENCE_NAME	MIN_VALUE	MAX_VALUE	INCREMENT_BY	CYCLE_FLAG	ORDER_FLAG	CACHE_SIZE	LAST_NUMBER
SEQ_TRD_REFNO	1	999999999999999999999999999	1	N	N	0	9532

Now I want to update the sequence to set the LAST_NUMBER as currentval + 900000000.I am a newbie to sequence in oracle. Can anyone help?

Locked Post

New comments cannot be posted to this locked post.

Locked on Nov 4 2013

Added on Oct 7 2013

10 comments

60,564 views