/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

4 votes102 views3 answers
Oracle sql first day of quarter
SQL
2 votes123 views2 answers
Mysql search for column name in all tables
SQL
0 vote105 views1 answer
Mysql grant all on all databases
SQL
1 vote109 views2 answers
Duplicate key value violates unique constraint "django_admin_log_pkey"
SQL
25 votes133 views1 answer
How to update an attribute in MySQL
SQL
2 votes128 views1 answer
Install postgresql centos 5
SQL
0 vote124 views1 answer
Set Mamp mysql globally
SQL
2 votes148 views1 answer
Username sql
SQL
14 votes120 views3 answers
Oracle sql limit results
SQL
0 vote116 views1 answer
Mysql order by rand limit 1 really slow
SQL