/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 vote374 views1 answer
Alter domain sql
SQL
0 vote383 views1 answer
Sql query to find percentage of null values in a table
SQL
0 vote340 views1 answer
Postgresql get current user name
SQL
0 vote356 views1 answer
Sql server datetime to string
SQL
0 vote331 views1 answer
Update set with join pl sql
SQL
0 vote349 views1 answer
Sql server update top n records
SQL
-1 vote371 views2 answers
First letter capital in mysql query
SQL
0 vote437 views1 answer
How to add auto increment primary key
SQL
4 votes405 views1 answer
Mysql query first character
SQL
0 vote371 views1 answer
Find usage of table in sql server
SQL