/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 vote156 views1 answer
Dump db only triggers mysql
SQL
5 votes146 views4 answers
Describe table postgres
SQL
0 vote193 views1 answer
Postgres docs /copy metacomand
SQL
1 vote166 views1 answer
How to set up a trigger in sql
SQL
0 vote145 views1 answer
R2dbc-postgresqldriver dependency
SQL
0 vote200 views1 answer
How to make full text search dynamic in mysql
SQL
1 vote147 views1 answer
Mysql get character set
SQL
1 vote194 views1 answer
Sqlite create index
SQL
0 vote164 views1 answer
How to select a row in sql
SQL
1 vote172 views1 answer
Mysql find tables with column name
SQL