web analytics
How to change start value of a sequence in Oracle? Options
codeling
Posted: Wednesday, January 30, 2019 9:16:20 AM

Rank:Advanced Member
Groups: Member
Joined: 12/11/2015
Posts: 994
Points: 4191

You can use the following statement to change the value of a sequence without recreating it.

ALTER SEQUENCE dev.my_sequence INCREMENT BY 500;

The start value of the sequence will be increased by 500.

Sponsor
Posted: Wednesday, January 30, 2019 9:16:20 AM
 
Users browsing this topic
Guest

Forum Jump
You cannot post new topics in this forum.
You cannot reply to topics in this forum.
You cannot delete your posts in this forum.
You cannot edit your posts in this forum.
You cannot create polls in this forum.
You cannot vote in polls in this forum.


© 2019 Digcode.com. All rights reserved.