<\/span><\/h2>\nOne way to decrease the value of a sequence in Oracle is by using negative values as increments or decrements. By default, a sequence increments by 1, but you can alter the sequence to use a negative increment to decrease the value.<\/p>\n
To do this, you can use the `INCREMENT BY` clause to set a negative value as the increment:<\/p>\n
ALTER SEQUENCE my_sequence INCREMENT BY -1;<\/code><\/p>\nOnce you have set the negative increment, you can fetch the next sequence value with the following query:<\/p>\n
SELECT my_sequence.NEXTVAL FROM dual;<\/code><\/p>\nThis will decrement the value of the sequence by 1.<\/p>\n