• 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;

0 comments:

Leave a Reply

Thanks for sharing your feedback! If your feedback doesn't appear right away, please be patient as it may take a few minutes to publish - or longer if the blogger is moderating comments.