If I leave out the "INCREMENT BY" in a sequence, does it automatically just increment by one? I am realizing I checked in code to start a sequence and left out the "INCREMENT BY" statement. However, once I view the sequence in my schema, It shows the sequence is set to incrementing by 1. Just trying to figure out if I need to check out that code and make changes or is it fine.
>Solution :
As documentation says:
INCREMENT BY
Specify the interval between sequence numbers. This
integer value can be any positive or negative integer, but it cannot
be 0. This value can have 28 or fewer digits for an ascending sequence
and 27 or fewer digits for a descending sequence. The absolute of this
value must be less than the difference of MAXVALUE and MINVALUE. If
this value is negative, then the sequence descends. If the value is
positive, then the sequence ascends. If you omit this clause, then
the interval defaults to 1.