/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

1 vote153 views1 answer
Sql how to replace full stop
SQL
0 vote161 views1 answer
Cube oracle
SQL
0 vote172 views1 answer
Openquery update linked server
SQL
10 votes152 views2 answers
SQL rounding numbers
SQL
1 vote136 views2 answers
SQLSTATE[42000]: Syntax error or access violation: 1075 Incorrect table definition; there can be only one auto column and it must be defined as a key"
SQL
1 vote151 views1 answer
Replace all numbers in mysql
SQL
1 vote171 views1 answer
Error cs1061 'dbcontextoptionsbuilder' does not contain a definition for 'usesqlserver'
SQL
0 vote160 views1 answer
How to map sql column to custom names
SQL
3 votes142 views1 answer
Sql case update
SQL
3 votes172 views5 answers
Duplicate table sql
SQL