/SQL/Alter sequence set current value oracle

Alter sequence set current 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

5 votes126 views5 answers
Sqlite install python
SQL
0 vote121 views1 answer
Sql new line output
SQL
2 votes131 views1 answer
Mysql set value as null
SQL
0 vote125 views1 answer
Resulting Query
SQL
1 vote129 views1 answer
Oracle db create new schema
SQL
2 votes162 views2 answers
Postgres set user as superuser
SQL
0 vote127 views1 answer
Authentication in sql server
SQL
0 vote130 views1 answer
Sql last 7 days
SQL
1 vote87 views1 answer
Athena query timestamp greater than
SQL
0 vote138 views1 answer
How to insert multiple values in a single column in sql
SQL