/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 vote250 views1 answer
Select milliseconds mysql
SQL
0 vote157 views1 answer
Oracle list chain steps
SQL
3 votes182 views1 answer
Select database in sql
SQL
0 vote233 views1 answer
Mac os zsh: command not found: mysql
SQL
0 vote180 views1 answer
"/** MySQL database password */" ext:txt | ext:cfg | ext:env | ext:ini
SQL
2 votes194 views1 answer
Create delete procedure mysql
SQL
4 votes169 views1 answer
Change nls_date_format
SQL
1 vote184 views1 answer
Mysql select and count left join
SQL
0 vote338 views1 answer
Postrgesql concat 2 columns divided by ;
SQL
1 vote163 views1 answer
Spring postgresql reset auto increment to 0
SQL