/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

11 votes107 views2 answers
Having keyword sql
SQL
1 vote113 views1 answer
Spark sql concatenate string and int
SQL
0 vote124 views1 answer
Print boolean in plsql
SQL
0 vote126 views1 answer
Sql values that contains certain multiple ids
SQL
0 vote125 views1 answer
Sql sum if
SQL
1 vote115 views1 answer
T-SQL Alter the column data type
SQL
0 vote121 views1 answer
Convert multiple columns to ROws in sql server
SQL
0 vote107 views4 answers
Sql year
SQL
3 votes114 views1 answer
Sql multiple column index
SQL
0 vote104 views1 answer
Mysql update sum same table
SQL