/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

1 vote179 views1 answer
Pl sql insert into table
SQL
4 votes175 views4 answers
Oracle tablespace tables list
SQL
3 votes185 views1 answer
Oracle get trigger ddl
SQL
2 votes211 views6 answers
In operator in sql
SQL
0 vote185 views1 answer
Shell script to log mysql cpu usage
SQL
0 vote206 views1 answer
Postgres full text search example
SQL
1 vote165 views1 answer
Adding indexing on a db model in mysql using sequelize
SQL
2 votes168 views1 answer
How to select first row of database sql
SQL
6 votes162 views5 answers
Alter table oracle
SQL
13 votes186 views2 answers
Sql join 3 tables
SQL