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 vote175 views1 answer
How to install sql in anaconda
SQL
1 vote182 views1 answer
T-sql disable system versioning
SQL
1 vote179 views1 answer
Postgres get month name from date
SQL
3 votes169 views3 answers
How to set up an auto incrementing id db browser
SQL
5 votes218 views2 answers
Functions
SQL
3 votes214 views2 answers
Check data in table mysql
SQL
1 vote136 views1 answer
Oracle boolean to varchar
SQL
0 vote185 views1 answer
Object of class sendgrid\mail\mail could not be converted to string
SQL
0 vote198 views1 answer
Sql find gaps in date ranges
SQL
7 votes199 views2 answers
Html to react converter
SQL