/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 vote270 views1 answer
Flask sqlalchemy decimal
SQL
0 vote323 views1 answer
Wordpress make wp user in db
SQL
3 votes282 views2 answers
Sql select data from last week
SQL
10 votes290 views2 answers
Oracle alter sequence nextval
SQL
9 votes530 views2 answers
Current date in postgresql minus 1 day
SQL
25 votes273 views1 answer
Mysql grant all privileges to a user
SQL
0 vote281 views1 answer
Java check if something is in mysql table
SQL
0 vote281 views1 answer
How to see password mysql vestacp
SQL
0 vote297 views1 answer
Reindex mssql table
SQL
3 votes274 views1 answer
Oracle apex call duration
SQL