Oracle reset sequence

SELECT LAST_NUMBER FROM ALL_SEQUENCES WHERE SEQUENCE_NAME = 'seq_name';

ALTER SEQUENCE seq_name INCREMENT BY 100;	-- Value to reach desired value - 1
SELECT seq_name.nextval FROM dual;			-- Reinitialize value to desired
ALTER SEQUENCE seq_name INCREMENT BY 1;		-- Back to init step

Similar codes

4 votes125 views1 answer
Phone number sql
SQL
1 vote128 views1 answer
Postgres concat_ws
SQL
0 vote138 views1 answer
Dialect undefined does not support db:create / db:drop commands
SQL
0 vote128 views1 answer
Flush user resource mysql
SQL
13 votes84 views2 answers
Oracle all source
SQL
0 vote117 views1 answer
Sqldf change user
SQL
1 vote121 views1 answer
Substr sql last character
SQL
0 vote149 views1 answer
To Create directory
SQL
0 vote120 views2 answers
Sql drop view if exists
SQL
1 vote127 views1 answer
Oracle duration between timestamps
SQL