/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

2 votes152 views6 answers
Mysql change timezone
SQL
10 votes155 views2 answers
Mysql remove only_full_group_by permanently
SQL
0 vote186 views1 answer
Uncaught PDOException: SQLSTATE[HY000] [1698]
SQL
1 vote141 views2 answers
Mysql show views
SQL
2 votes144 views1 answer
SELECT INTO
SQL
2 votes166 views2 answers
Sql query to copy data from one column to another
SQL
0 vote151 views1 answer
Ffeathers express mysql application users login
SQL
9 votes169 views3 answers
Sequence postgresql
SQL
1 vote151 views1 answer
How to check the mysql version mac
SQL
0 vote143 views1 answer
Postgres float to int
SQL