/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 vote269 views1 answer
Mysql error 1452
SQL
0 vote276 views1 answer
Port 5432 is already in use Usually this means that there is already a PostgreSQL server running on your Mac. If you want to run multiple servers simultaneously, use different ports.
SQL
0 vote255 views1 answer
Sql cheetsheet
SQL
5 votes285 views1 answer
Oracle add time to date
SQL
11 votes259 views4 answers
Round in sql
SQL
0 vote262 views1 answer
Drop column from table if exist on live server mysql
SQL
14 votes274 views3 answers
This is incompatible with sql_mode=only_full_group_by laravel
SQL
0 vote277 views1 answer
Sql where part of string match
SQL
0 vote265 views1 answer
Postgresql print variable
SQL
7 votes269 views2 answers
Sql empty table
SQL