Sql

Search

set sequence value oracle

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

Comment

PREVIOUS	NEXT

Code Example
Sql :: how to alter table name in mysql
Sql :: oracle next run dates
Sql :: mysql date diff in seconds
Sql :: delete a view sql
Sql :: show indexes mysql
Sql :: postgresql format date dd/mm/yyyy
Sql :: Erreur SQL sur la requête Index column size too large. The maximum column size is 767 bytes.
Sql :: mysql id reset
Sql :: how to check database size mysql
Sql :: postgres remove foreign key constraint
Sql :: create a table with an id in mysql
Sql :: check sql database table lock
Sql :: convert float to int sql
Sql :: oracle list tablespaces
Sql :: sql change password wordpress
Sql :: how to check even or odd in sql
Sql :: duplicate column values sql
Sql :: Query the list of CITY names from STATION that do not start with vowels and do not end with vowels. Your result cannot contain duplicates.
Sql :: sql server roles and users
Sql :: distincct sql
Sql :: how to describe a table in sqlite3
Sql :: mysql smallint range
Sql :: add days in oracle sql
Sql :: postgresql CREATE EXTENSION pgcrypto
Sql :: postgres list tables and row counts
Sql :: postgres format date in select
Sql :: oracle alter table add column not null
Sql :: show all public tables postgres
Sql :: oracle asynchronous update
Sql :: find wordpress version in database

Search

SQL

set sequence value oracle

ADD CONTENT