Oracle sequence reset Statement 2

Oracle reset sequence Statement 2 SQL code www.2cto.com CREATE OR REPLACE PROCEDURE RESET_SEQUENCE (p_sSeqName IN VARCHAR2) IS n NUMBER (10); tsql VARCHAR2 (100 ); begin execute immediate 'select' | p_sSeqName | '. nextval from dual 'into n; n: =-(n-1); tsql: = 'alter sequence '| p_sSeqName | 'crement by' | n; execute immediate tsql; execute immediate 'select' | p_sSeqName | '. nextval from dual 'into n; tsql: = 'alter sequence '| p_sSeqName | 'crement by 1'; execute immediate tsql; exception when others then null; END RESET_SEQUENCE;