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 vote200 views2 answers
How to find sql server agent jobs related to a database
SQL
0 vote187 views1 answer
Mysql select where text contains
SQL
10 votes206 views2 answers
Show tables in schema oracle
SQL
1 vote254 views2 answers
Sql split string by space
SQL
1 vote160 views1 answer
Convert money to varchar sql server
SQL
0 vote257 views1 answer
Sql server python connection
SQL
0 vote194 views1 answer
How to put 0 or 000 depending IDCustomer length in sql server
SQL
2 votes182 views2 answers
Join update query in sql
SQL
1 vote247 views1 answer
Add time to date sql
SQL
2 votes202 views4 answers
Sql query interview questions
SQL