Inserting nextval after sequence has reached maximum value
What will happen when a sequence has reached the maximum value and we try to insert the nextval of the sequence?
Eg. A sequence has a maximum value of 999 and it has crossed. Now i try to insert a value through sequence_name.nextval() and the cycle option was not mentioned while creating the sequence.
Re: Inserting nextval after sequence has reached maximum value
well innila gave the correct reply. if the paramater for returning to the starting value is off then an error will be there else if cycle is present then it ll start from the beginning value. like if we have start value 1
max value 99
then if cycle is there then after 99 it ll start from 1 else will return a value.