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 vote185 views1 answer
Copy value from one column to another postgres
SQL
1 vote195 views1 answer
How to fetch alternate records from two tables
SQL
0 vote205 views1 answer
Like date sql server not working
SQL
0 vote178 views1 answer
Psql list rules
SQL
0 vote193 views1 answer
Databricks install odbc driver connect to sql server
SQL
0 vote178 views1 answer
Postgres add prefix to primary key
SQL
0 vote202 views1 answer
No suitable driver found for sqlite
SQL
0 vote170 views1 answer
Limiting query result using where in sql
SQL
0 vote210 views1 answer
Stored procedure to change name of column for all dependent tables and views
SQL
0 vote207 views1 answer
Sql statement show all emails with dome
SQL