/SQL/Oracle alter sequence restart start with

Oracle alter sequence restart start with

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 vote280 views1 answer
Postgres select as csv
SQL
0 vote218 views1 answer
Compare if is null sql
SQL
1 vote225 views1 answer
Postgres get month name from date
SQL
0 vote174 views2 answers
Avg() sql
SQL
0 vote228 views2 answers
Sql if empty then
SQL
0 vote207 views1 answer
How to take sum of column with same id in "JPQL?"
SQL
1 vote273 views1 answer
Backup mysql schema only
SQL
0 vote202 views1 answer
Sql drop procedure if exists
SQL
0 vote201 views1 answer
How to check the port of mysql installation in mac
SQL
0 vote205 views1 answer
Find invalid datetime field
SQL