Resets the oracle sequence from a specified number.

Resets the oracle sequence from the specified number. The SQL code www.2cto.com declare n number (10); v_startnum number (10): = 10000001; -- the number of v_step numbers (10): = 1; -- step tsql varchar2 (200); v_seqname varchar2 (200): = 'mip _ JF_SEQUENCE '; -- sequence name begin execute immediate 'select' | v_seqname | '. nextval from dual 'into n; n: = v_startnum-n-v_step; -- Starting from 10000001 tsql: = 'alter sequence '| v_seqname | 'increment by' | n; execute immediate tsql; execute immediate 'select' | v_seqname | '. nextval from dual 'into n; tsql: = 'alter sequence '| v_seqname | 'increment by' | v_step; execute immediate tsql; end ;/