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 vote321 views1 answer
Proc sql not in working
SQL
1 vote329 views3 answers
Sql union
SQL
0 vote280 views1 answer
Store query result in variable sql
SQL
10 votes299 views1 answer
Create table oracle
SQL
6 votes309 views4 answers
Rror: ER_NOT_SUPPORTED_AUTH_MODE: Client does not support authentication protocol requested by server; consider upgrading MySQL client
SQL
9 votes292 views3 answers
Where in sql
SQL
6 votes330 views2 answers
Mysqldump password in file
SQL
1 vote307 views1 answer
Access the postgres psql
SQL
1 vote323 views1 answer
Oracle check table lock
SQL
1 vote322 views1 answer
SQL query to get all table records count from a database
SQL