/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

7 votes356 views3 answers
Select latest entry in sql table
SQL
10 votes334 views2 answers
Forgot my mysql password mac
SQL
0 vote289 views1 answer
Mysql select top 2
SQL
4 votes362 views1 answer
Id increment ms sql server
SQL
4 votes350 views2 answers
Postgre sql create table
SQL
6 votes366 views2 answers
Mysql 1 day ago
SQL
0 vote359 views2 answers
Uncaught Error: Cannot use object of type mysqli_result as array
SQL
0 vote371 views1 answer
Second Step in installing SQL workbench
SQL
1 vote351 views1 answer
Sometimes i cant edit sql developer
SQL
5 votes332 views3 answers
Mysql check if null or empty string
SQL