/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

0 vote142 views1 answer
Oracle right characters
SQL
12 votes146 views1 answer
Script to add new column in table sql
SQL
6 votes137 views3 answers
Update with inner join postgres
SQL
0 vote181 views1 answer
Postgres select from values
SQL
2 votes148 views1 answer
How to get weekday from old date in sql
SQL
1 vote147 views2 answers
Datetrunc hour snowflake
SQL
0 vote155 views1 answer
Warning: pdostatement::execute(): sqlstate[hy093]: invalid parameter number: number of bound variables does not match number of tokens
SQL
0 vote141 views1 answer
Error-expression-select-list-not-group-by-nonaggregated-column/
SQL
6 votes128 views3 answers
Can you update NULL in sql
SQL
11 votes149 views1 answer
Sql insert multiple rows from select
SQL