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

4 votes134 views4 answers
Remove duplicate old value in mysql
SQL
0 vote111 views2 answers
T SQl Checking Your Username
SQL
1 vote104 views1 answer
Sql auto date
SQL
0 vote221 views1 answer
How to delete duplicate rows in oracle
SQL
0 vote106 views1 answer
How to reset table in sql server
SQL
0 vote114 views1 answer
Spark sql grows beyond 64 kb
SQL
50 votes205 views6 answers
Sql count duplicate rows
SQL
0 vote109 views1 answer
Could not assemble any primary key columns for mapped table sqlalchemy
SQL
0 vote117 views1 answer
If column value is null then in mysql
SQL
16 votes107 views2 answers
Sql exists
SQL