Oracle reset sequence

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

Similar codes

0 vote115 views1 answer
How to insert a uniqueidentifier in sql
SQL
0 vote118 views1 answer
Mysql query single row
SQL
4 votes110 views2 answers
Could not find driver (SQL: select * from information_schema.tables where table_schema = pics and table_name = migrations and table_type = 'BASE TABLE')
SQL
4 votes124 views2 answers
How to insert ip address in mysql using php
SQL
0 vote105 views1 answer
PG::ForeignKeyViolation: ERROR: update or delete on table violates foreign key constraint
SQL
0 vote113 views1 answer
Sql contains numeric characters
SQL
0 vote137 views1 answer
Sql today at midnight
SQL
0 vote118 views1 answer
Mariadb errno 121
SQL
0 vote138 views1 answer
How to define a save method in ruby for sqlite3 databases
SQL
13 votes114 views11 answers
ERROR 2002 (HY000): Can't connect to local MySQL server through socket '/var/run/mysqld/mysql.sock' (2) Ask
SQL