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 vote309 views1 answer
Least spark sql
SQL
0 vote287 views1 answer
Mysql select where field like in list
SQL
2 votes294 views2 answers
Postgresql search all tables for column name
SQL
17 votes295 views6 answers
MySQL ORDER BY
SQL
4 votes295 views1 answer
Mysql ip address data type
SQL
2 votes240 views2 answers
Mysql get last character of string
SQL
2 votes311 views3 answers
How do I add a user to a postgres database? cli
SQL
0 vote280 views1 answer
Oracle sql generate list of days
SQL
0 vote299 views1 answer
Groupby sort sql hive
SQL
2 votes297 views1 answer
Sql as
SQL