/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 vote329 views2 answers
Sql trigger difference between for and after
SQL
0 vote337 views1 answer
Sql count null values in all columns
SQL
1 vote388 views4 answers
How to check table in postgresql from terminal
SQL
0 vote381 views3 answers
Characters found after end of sql statement
SQL
59 votes557 views6 answers
Alter table sql
SQL
1 vote322 views2 answers
Sql multiline comment
SQL
6 votes774 views3 answers
Sql select last id
SQL
2 votes329 views1 answer
Oracle current date without time
SQL
1 vote357 views5 answers
What is in operator in sql
SQL
1 vote318 views1 answer
T-SQL Alter the column data type
SQL