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

6 votes292 views2 answers
Subtr Oracle ?
SQL
37 votes334 views6 answers
Mysql update
SQL
0 vote266 views3 answers
Java hide mysql login credentials
SQL
4 votes232 views2 answers
What is table in sql
SQL
16 votes260 views3 answers
Tsql rename column name
SQL
2 votes277 views3 answers
Sql server: how to concatenate column data using comma
SQL
0 vote264 views1 answer
Hibernate show sql xml property
SQL
8 votes258 views1 answer
Today minus 15 days postgresql
SQL
0 vote259 views1 answer
Create table with float datatype in sql server
SQL
2 votes255 views1 answer
Find all triggers in database
SQL