/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 vote363 views1 answer
How to select an index in oracle sql
SQL
3 votes407 views1 answer
Mysql group_concat distinct
SQL
4 votes369 views2 answers
Sql offset
SQL
19 votes366 views5 answers
Change column name mysql command line
SQL
0 vote385 views1 answer
Postgresql find missing id
SQL
0 vote381 views1 answer
Normalization in database
SQL
0 vote460 views1 answer
Mysql get nested records
SQL
0 vote337 views0 answer
SQL
0 vote344 views1 answer
Sql server select ignore dupplicates
SQL
3 votes406 views3 answers
Mysql declare variable
SQL