/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 vote187 views1 answer
Postgres sql alter table delete row
SQL
1 vote192 views1 answer
Update and replace mysql
SQL
0 vote187 views1 answer
Use between operator in mysql
SQL
0 vote185 views1 answer
Postgres create extension if not exists
SQL
0 vote218 views1 answer
Datagrip go to line
SQL
1 vote378 views3 answers
Create table from existing table in sql
SQL
-2 votes193 views2 answers
Sqlserver docker
SQL
0 vote236 views1 answer
Sql select first and last record of each group
SQL
0 vote197 views1 answer
Sqlite explain plan
SQL
10 votes191 views4 answers
SELECT FROM WHERE
SQL