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;

No comments:

Post a Comment