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

0 vote395 views1 answer
Hibernate dialect property xml for mysql 8
SQL
0 vote367 views1 answer
Sql character index
SQL
0 vote427 views1 answer
Mssql last day of month
SQL
0 vote391 views1 answer
Declare or use variable in snowflake
SQL
5 votes358 views1 answer
How to check nls format in oracle
SQL
0 vote374 views1 answer
Mysql make date from 2 column
SQL
0 vote354 views1 answer
Select all tables linked server sql
SQL
0 vote378 views1 answer
How to add session data into mysql database from button
SQL
-1 vote379 views2 answers
Postgresql get last 10 records
SQL
0 vote341 views1 answer
Psql no such file or directory
SQL