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

7 votes228 views5 answers
Sql remove spaces
SQL
2 votes181 views1 answer
Oracle virtual column
SQL
0 vote313 views1 answer
Provera dupliranih konatakata
SQL
10 votes193 views2 answers
SQL rounding numbers
SQL
4 votes211 views1 answer
Describe table mysql
SQL
0 vote198 views1 answer
Mysql change innodb to myisam
SQL
0 vote174 views1 answer
Incorrect datetime value sql table error 1292
SQL
2 votes180 views1 answer
Oracle sql day of month from date
SQL
0 vote195 views1 answer
Sql query to get contact form 7 fields
SQL
0 vote186 views1 answer
Create database store
SQL