/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

0 vote157 views1 answer
No suitable driver found for sqlite
SQL
1 vote164 views1 answer
Add sequence postgres
SQL
3 votes152 views2 answers
How to force truncate a table in mysql
SQL
2 votes134 views2 answers
Exec procedure pl sql
SQL
2 votes147 views1 answer
Oracle to_char number format percentage
SQL
0 vote129 views1 answer
"SET SQL_AUTO_IS_NULL = 0" query problem
SQL
50 votes238 views6 answers
Sql count duplicate rows
SQL
2 votes138 views1 answer
Oracle virtual column
SQL
0 vote166 views2 answers
Oracle ora-00054 how to unlock
SQL
0 vote131 views1 answer
Postgresql newline character
SQL