/SQL/Oracle alter sequence restart start with

Oracle alter sequence restart start with

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 vote249 views1 answer
Sql with example
SQL
1 vote227 views1 answer
Join to find results not in another table
SQL
9 votes230 views1 answer
Alter table column change data type to text mysql
SQL
0 vote227 views1 answer
Mysql join same table multiple times group by
SQL
0 vote286 views1 answer
Dialect undefined does not support db:create / db:drop commands
SQL
3 votes232 views2 answers
MySQL query to get column names
SQL
0 vote237 views1 answer
Check if string is a number sql
SQL
6 votes280 views3 answers
Check if string contains substring sql
SQL
2 votes272 views3 answers
How to replace null values in sql
SQL
0 vote222 views1 answer
Get first monday of month sql
SQL