Showing posts with label Oracle. Show all posts
Showing posts with label Oracle. Show all posts

Tuesday, 29 November 2011

How to reset the start value of Oracle Sequence?

Alter Sequence SEQ_TX_ID Increment By 1000;
Select SEQ_TX_ID.NextVal From Dual;
Alter Sequence SEQ_TX_ID Increment By 1;