Oracle alter sequence nextval

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

Select nextval from sequence oracle

SELECT schema.seq_name.NEXTVAL FROM dual;

INSERT INTO table_name (VALUE1) VALUES (
	schema.seq_name.NEXTVAL AS VALUE1
);

Source: dba-oracle.com

Similar codes

4 votes386 views1 answer
Ms sql truncate table vs delete
SQL
0 vote296 views0 answer
How to connect to datbase in springboot
SQL
15 votes360 views5 answers
If null mysql
SQL
-1 vote359 views3 answers
SQL to LINQ converter
SQL
2 votes354 views1 answer
How to insert string variable into sqlite database
SQL
0 vote390 views1 answer
Soql queries for not contact related account records in salesforce
SQL
0 vote414 views2 answers
How to check if a column exists in a SQL Server table?
SQL
0 vote365 views1 answer
Column ' ' in field list is ambiguous
SQL
0 vote364 views1 answer
Sql last time database was accessed
SQL
0 vote364 views1 answer
Close sql query vb.net
SQL