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 vote317 views1 answer
Mysql select statement after index
SQL
10 votes305 views2 answers
Reset mysql root password mac
SQL
0 vote302 views1 answer
On update current_timestamp jpa
SQL
5 votes311 views3 answers
Mysql extract month from date
SQL
9 votes334 views4 answers
How to alter table column name in mysql
SQL
0 vote334 views1 answer
Mysql last 6 months
SQL
0 vote306 views1 answer
Sql server remove 0 from left
SQL
0 vote318 views1 answer
Mysql count unique in group statement
SQL
0 vote312 views1 answer
Add unique constraint sql server multiple columns
SQL
8 votes310 views1 answer
Oracle search source code
SQL