/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

2 votes166 views1 answer
How to create sql database
SQL
0 vote132 views1 answer
Now() -1 mysql
SQL
1 vote174 views1 answer
Create sqlite database in laravel
SQL
0 vote181 views1 answer
Ignore case in string sql
SQL
2 votes181 views1 answer
Postgresql update sequence next value
SQL
1 vote171 views1 answer
Mysql not supported auth mode
SQL
9 votes157 views3 answers
Mysql get last id
SQL
0 vote188 views1 answer
Sql use with to get value counts and percentages
SQL
0 vote250 views2 answers
Mysql insert rows to another database
SQL
2 votes185 views1 answer
Set auto increment from 1
SQL