-
Oracle Sequence Decrease
Very simple .
You can decrease the number of your current sequence .
Important to set the nextval, so that the new value will be caught in the sequence.
And most important to change back the increment by 1 , otherwise it will decrease each time you"ll activate the sequence by the negative number you've defined in the first row.
alter sequence customer_seq increment by -40;
select customer_seq.nextval from dual;
alter sequence customer_seq increment by 1;
Subscribe to:
Post Comments (Atom)
0 comments: