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

7 votes171 views1 answer
Mysql load data infile csv
SQL
0 vote206 views1 answer
EneratingSchemaError: Some errors occurred while generating GraphQL schema: Type Query must define one or more fields.
SQL
0 vote219 views2 answers
Postgres show current role
SQL
0 vote206 views1 answer
Google sheets filter rows above current cell
SQL
6 votes196 views5 answers
Alter table oracle
SQL
3 votes193 views2 answers
Sql paging query
SQL
1 vote205 views1 answer
Apex ORA-20999
SQL
15 votes194 views4 answers
Mysql where value is null
SQL
0 vote239 views1 answer
Psql store procedure-return multiple table values
SQL
2 votes196 views2 answers
Change varchar length mysql
SQL