/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

2 votes111 views1 answer
Codeigniter print last sql query
SQL
0 vote127 views1 answer
How to set sql_mode for a query in CI model
SQL
50 votes217 views6 answers
Install mysql on ubuntu
SQL
1 vote129 views2 answers
Sql convert datetime to year month
SQL
0 vote132 views1 answer
Mysql get last 2 month data
SQL
4 votes115 views2 answers
Postgresql reset sequence
SQL
0 vote117 views1 answer
Sql server whoami
SQL
0 vote134 views1 answer
Is there a way to use read_sql_query and the query has WHERE column = Variable?
SQL
26 votes133 views2 answers
Mysql workbench download
SQL
1 vote128 views2 answers
Pad zero sql server
SQL