/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 vote225 views1 answer
Delete mysql from mac
SQL
2 votes250 views2 answers
Storing timezones in postgres
SQL
4 votes236 views2 answers
Mysql show indexes on table
SQL
0 vote235 views1 answer
Oracle merge insert if not exists
SQL
0 vote230 views1 answer
Incorrect string value: mysql
SQL
3 votes261 views2 answers
Oracle drop sequence
SQL
1 vote247 views1 answer
Oracle drop job if exists
SQL
0 vote270 views1 answer
Exception message: The connection name 'SqlServices' was not found in the applications configuration or the connection string is empty.
SQL
5 votes289 views1 answer
Oracle ora-00054 find
SQL
0 vote273 views1 answer
Database disk image is malformed sqlite fix ubuntu
SQL