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 vote188 views2 answers
Cascade syntax in sql
SQL
19 votes147 views6 answers
Sql server drop table if exists
SQL
0 vote137 views1 answer
Inner joint
SQL
1 vote133 views1 answer
Create table tablename as select * from tablename
SQL
27 votes165 views6 answers
Sql update record
SQL
12 votes145 views1 answer
Psql drop column
SQL
1 vote138 views1 answer
Found option without preceding group in config file: /etc/mysql/mariadb.conf.d/50-server.cnf at line: 1
SQL
0 vote164 views1 answer
Alling a function from PL/SQL in a select statement in ORACLE
SQL
0 vote172 views1 answer
Mysql last friday of current month
SQL
4 votes155 views1 answer
Conda install sqlalchemy
SQL