/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

3 votes193 views1 answer
Null sql
SQL
0 vote189 views1 answer
How to make case insensitive in sql
SQL
0 vote242 views1 answer
Import sql inside hide sql
SQL
13 votes201 views2 answers
Sql join
SQL
1 vote205 views1 answer
Liquibase alter column type / length
SQL
0 vote203 views1 answer
Postgres grep entire database
SQL
1 vote188 views1 answer
Temp table vs variable table in sql server
SQL
2 votes220 views1 answer
Sql OR
SQL
0 vote195 views1 answer
Left join vs inner join performance
SQL
18 votes193 views6 answers
Create table mysql
SQL