Introduction to Resetting oracle sequence statements

The oracle sequence statement may be used during development. This article describes how to reset the oracle sequence statement. For more information, see
Oracle reset sequence Statement 1
SQL code
Copy codeThe Code is as follows:
DECLARE
N NUMBER (10 );
Tsql VARCHAR2 (100 );
P_seqName varchar2 (20 );
BEGIN
P_seqName: = 'seq _ RUN_ID ';
Execute immediate 'select' | p_seqName | '. nextval from dual' INTO n;
N: =-(n-1 );
Tsql: = 'alter sequence '| p_seqName | 'crement by' | n;
Execute immediate tsql;
Execute immediate 'select' | p_seqName | '. nextval from dual' INTO n;
Tsql: = 'alter sequence '| p_seqName | 'crement by 1 ';
Execute immediate tsql;
EXCEPTION
WHEN OTHERS THEN
Dbms_output.put_line (SQLERRM );
END;

Oracle sequence reset Statement 2
SQL code
Copy codeThe Code is as follows:
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;