/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 vote321 views1 answer
Copied text from internet not inserting in mysql
SQL
0 vote328 views1 answer
Sql replace id with name from another table
SQL
1 vote318 views2 answers
Mysql join two tables
SQL
8 votes324 views1 answer
Oracle tablespace datafile max size
SQL
6 votes361 views2 answers
Mysql convert timestamp to date
SQL
2 votes328 views1 answer
Illuminate\Database\QueryException : SQLSTATE[HY000] [1698] Access denied for user 'root'@'localhost'
SQL
0 vote339 views1 answer
Excel vba import data to sql server
SQL
0 vote336 views1 answer
Insert or update sql query
SQL
0 vote312 views1 answer
Error-expression-select-list-not-group-by-nonaggregated-column/
SQL
7 votes307 views1 answer
Oracle set sequence value to max(id)
SQL