Change sequence oracle

-1

How do I update the sequence value?

Situation: I'm going to create a sequence but this table may be either registered or unconfigured. So how do I generate the sequence 0 or so with value since there is already a record?

create sequence S_SEG_EXE;

    
asked by anonymous 26.07.2018 / 19:02

1 answer

2

You can use ALTER SEQUENCE :

ALTER SEQUENCE S_SEG_EXE INCREMENT BY 100;

In the example above, the current value of the sequence has been increased by 100. The value can be negative also if you want to reduce the value.

    
26.07.2018 / 19:20