Set sequence 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 vote109 views1 answer
Check if due date is less than todays date sql
SQL
1 vote151 views1 answer
Sqlite check if row exists
SQL
1 vote155 views1 answer
Select users with same username
SQL
1 vote143 views3 answers
Mariadb add foreign key
SQL
0 vote255 views1 answer
How to get all values in a table mysql in c#
SQL
0 vote164 views1 answer
How to alter length character varying postgres
SQL
-1 vote169 views1 answer
Capitole toulouse
SQL
1 vote175 views4 answers
How to check table in postgresql from terminal
SQL
3 votes186 views1 answer
Mysql cli connect with password
SQL
4 votes109 views2 answers
Create table if not exists postgres
SQL