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 vote134 views1 answer
Create a table from one field of another table
SQL
0 vote142 views1 answer
Drop-toys-table
SQL
1 vote133 views1 answer
Update from table tsql
SQL
9 votes133 views2 answers
Cmd to rename a collumn name in sql
SQL
3 votes145 views4 answers
Show databases in sql server
SQL
0 vote156 views1 answer
How to find sql server name
SQL
0 vote183 views1 answer
How to drop a column in mysql laravel stackoverflow
SQL
0 vote148 views1 answer
Sql select all records from all tables where not empty
SQL
0 vote169 views1 answer
Insert output identity
SQL
-1 vote149 views2 answers
Create temporary table sql
SQL