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

1 vote266 views1 answer
Type int in mysql maxlenght
SQL
11 votes292 views2 answers
You are using safe update mode
SQL
0 vote298 views1 answer
Sql log file inof
SQL
5 votes276 views1 answer
Com.mysql.jdbc.exceptions.jdbc4.MySQLNonTransientConnectionException: Public Key Retrieval is not allowed
SQL
0 vote250 views1 answer
Hallo
SQL
3 votes426 views9 answers
Linq to sql converter online
SQL
0 vote318 views1 answer
Remove mysql from centos 7
SQL
0 vote300 views1 answer
Mysql db dump restore max file size issue
SQL
1 vote279 views1 answer
Postgresql must appear in the group by clause or be used in an aggregate function
SQL
0 vote270 views2 answers
Mysql output csv
SQL