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 vote138 views1 answer
STOP message of how many rows affected sql
SQL
6 votes140 views2 answers
Postgresql restore from dump
SQL
0 vote124 views1 answer
Possgress drop if exists view
SQL
2 votes131 views2 answers
Mysql all columns
SQL
1 vote125 views1 answer
Set id count mysql
SQL
0 vote126 views1 answer
Add plugins to mysql workbench
SQL
1 vote147 views2 answers
Sql insert timestamp
SQL
5 votes128 views1 answer
Sqlite alter table add column
SQL
5 votes138 views1 answer
Add column table sql default value
SQL
0 vote173 views1 answer
For select oracle
SQL