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 vote303 views1 answer
Find usage of table in sql server
SQL
0 vote339 views1 answer
How to use sqlcommand
SQL
0 vote292 views1 answer
Sqlite higher or equal
SQL
3 votes327 views1 answer
How to add unique constraint in mysql table
SQL
1 vote286 views2 answers
Replace text in sql
SQL
0 vote319 views1 answer
Postgres foreign key multiple columns
SQL
15 votes326 views4 answers
Create table if not exists sql
SQL
13 votes304 views2 answers
Sql online compiler
SQL
4 votes294 views3 answers
Drop Table Oracle
SQL
0 vote287 views1 answer
Sql server udf performance
SQL