/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 vote273 views1 answer
Mysql workbench download for iinux mint 19.3
SQL
1 vote298 views1 answer
How to select the nth row in a SQL database table?
SQL
-1 vote309 views2 answers
Installing mysql on centos 7
SQL
0 vote274 views1 answer
FIND ABOVE AVERAGE SALARY EARNER IN SQL
SQL
1 vote308 views1 answer
Second last highest id in sql
SQL
7 votes280 views1 answer
Safe mode mysql
SQL
0 vote292 views1 answer
Like date sql server not working
SQL
0 vote286 views1 answer
Call rest api from postgresql
SQL
1 vote296 views1 answer
ORA-01950
SQL
2 votes328 views2 answers
Mysql compare datetime to another datetime
SQL