Skip to main content


Showing posts with the label DDL

Oracle How to reset Sequence without dropping it

In this article, we will learn how to reset Sequence to a particular value without dropping it. Let's suppose the current value of the sequence e.g seq_person_id is 10234 and we want to reset it to 100. Step 1 alter sequence  seq_person_id increment by -10134 minvalue 0 Note : MINUS sign with 10134. Step 2 select  seq_person_id.nextval from dual Step 3 alter sequence  seq_person_id  increment by 1 minvalue 0; The sequence is now reset to 100.