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

1 vote170 views1 answer
Mysql count all table rows
SQL
6 votes225 views3 answers
Mysql change auto_increment start value
SQL
1 vote178 views1 answer
Delete specific row in sql
SQL
0 vote182 views1 answer
Add sqlcmd to path linux
SQL
0 vote176 views1 answer
Select distinct after join
SQL
0 vote203 views1 answer
Como hacer un select entre fechas mysql
SQL
0 vote160 views1 answer
How to find sql server installation folder
SQL
0 vote198 views1 answer
Sql get latest of 2 datetimes
SQL
2 votes164 views2 answers
Exec procedure pl sql
SQL
0 vote171 views1 answer
Qt qsql check if table exist
SQL