/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 votes367 views2 answers
Check data in table mysql
SQL
0 vote345 views1 answer
Query params sql insert python f string
SQL
1 vote324 views2 answers
DROP TABLes regardless of constraints
SQL
5 votes367 views1 answer
Sql table columns
SQL
0 vote314 views1 answer
Insert to first table if field A equals field B from a second table using sql
SQL
0 vote348 views1 answer
How to select a row in sql
SQL
0 vote326 views1 answer
Psql check if value in array
SQL
0 vote348 views1 answer
Postgresql create query
SQL
3 votes358 views1 answer
Create a table with an id in mysql
SQL
0 vote350 views1 answer
What is the difference between the LIKE and REGEXP operators in mysql?
SQL