/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

1 vote333 views1 answer
Sqlstate[imssp]: the active result for the query contains no fields.
SQL
6 votes340 views4 answers
Mysql update set
SQL
0 vote325 views1 answer
Sql tablo sp
SQL
23 votes333 views3 answers
Sql where contains part of string
SQL
3 votes330 views1 answer
Mysql insert on dupèlicate
SQL
0 vote340 views1 answer
How to join result table in mysql
SQL
17 votes332 views4 answers
Mysql remove ubuntu
SQL
0 vote270 views1 answer
Count char in java
SQL
0 vote329 views1 answer
Group by 15 minute interval sql server
SQL
4 votes286 views2 answers
Select todays data postgres query
SQL