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

0 vote179 views1 answer
Day of the week sqlite
SQL
0 vote174 views1 answer
Sql today at midnight
SQL
0 vote198 views3 answers
Select top 10 rows in sql
SQL
2 votes143 views1 answer
Anonymous block plsql
SQL
0 vote145 views1 answer
Search column name sql
SQL
0 vote178 views1 answer
SQL get max per id
SQL
0 vote148 views1 answer
Psql select * from table
SQL
0 vote173 views1 answer
Mysql join only one column
SQL
3 votes155 views5 answers
Sql select
SQL
0 vote156 views1 answer
Add super privilege mysql
SQL