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 vote128 views1 answer
Json_remove mysql
SQL
0 vote128 views1 answer
Python sql last insertend
SQL
0 vote87 views1 answer
Get all stored procedures in sql server
SQL
0 vote147 views1 answer
Mysql persistence.xml
SQL
0 vote127 views1 answer
Sql string contains case sensitive
SQL
3 votes86 views1 answer
If 0 return null else return query mysql
SQL
0 vote121 views1 answer
Postgres set default schema
SQL
0 vote153 views1 answer
Where field is null sql knex
SQL
0 vote136 views1 answer
Oracle archivemode
SQL
0 vote142 views1 answer
ERROR: column "hourly_visitors.hour" must appear in the GROUP BY clause or be used in an aggregate function
SQL