/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 vote137 views1 answer
Table values functions in SQL
SQL
1 vote142 views2 answers
Mysql limit offset
SQL
51 votes368 views6 answers
Installing mysql on ubuntu
SQL
0 vote143 views1 answer
Select a row include list of array with join table SQL
SQL
1 vote136 views1 answer
Neo4j display all nodes and relationships
SQL
15 votes165 views4 answers
Sql update from select
SQL
4 votes149 views1 answer
Adding data to table in sql python
SQL
1 vote127 views1 answer
Can we drop a primary key
SQL
0 vote148 views1 answer
Sql server roles and users
SQL
3 votes137 views1 answer
Select count from table mysql
SQL