/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

1 vote252 views2 answers
OSError: mysql_config not found mysql_config --version mariadb_config --version mysql_config --libs ---------------------------------------- ERROR: Command errored out with exit status 1: python setup.py egg_info Check the logs for full command outpu
SQL
20 votes288 views2 answers
Counting in sql
SQL
3 votes271 views1 answer
Oracle detect invalid password
SQL
0 vote291 views1 answer
Postgresql remove new line from string
SQL
0 vote288 views1 answer
Sql waitfor
SQL
0 vote281 views1 answer
Não é possível executar uma operação DML dentro de uma consulta
SQL
0 vote296 views1 answer
Assign value to var in SQL
SQL
0 vote307 views1 answer
Mysql backup certain tables workbench
SQL
0 vote286 views1 answer
How to define a save method in ruby for sql databases
SQL
1 vote330 views1 answer
Oracle dbms scheduler repeat interval every 5 minutes
SQL