/SQL/Alter sequence set current value oracle

Alter sequence set current value oracle

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 vote197 views1 answer
Postgresql get current user name
SQL
3 votes260 views2 answers
Synonym oracle
SQL
18 votes214 views6 answers
Mysql create table
SQL
0 vote211 views1 answer
Sql select all records from all tables where not empty
SQL
0 vote233 views1 answer
Mariadb cast to int
SQL
0 vote226 views2 answers
Mysql decimal remove trailing zeros
SQL
11 votes232 views2 answers
You are using safe update mode
SQL
4 votes230 views2 answers
Mysql alter table set column unique
SQL
2 votes239 views2 answers
Postgres timestamp to datetime
SQL
1 vote230 views1 answer
How to select random rows from a table
SQL