Sql

Search

alter sequence set current 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 :: oracle alter sequence restart start with
Sql :: how to delete columns in sql
Sql :: influxdb export to csv
Sql :: count mysql server db tables
Sql :: update left join mysql
Sql :: what is meant by trigger in dbms
Sql :: alert table name mysql
Sql :: current setting postgres timezone
Sql :: how to see logical reads in sql server
Sql :: sql server add identity column to existing table
Sql :: STOP message of how many rows affected sql
Sql :: tsql find foreign key references
Sql :: mysql show table column full description
Sql :: postgresql show current database
Sql :: sql query to copy data from one column to another
Sql :: mysql between start date and end date
Sql :: oracle nls instance
Sql :: update substring in mysql
Sql :: delete all entries postgres
Sql :: What is the compatibility level of a SQL database
Sql :: mysql return if it contains
Sql :: mysql tinyint max value
Sql :: NOT LIKE sql laravel
Sql :: oracle search columns in schema
Sql :: set auto increment from 1
Sql :: mysql login console
Sql :: mysql trim whitespace
Sql :: hour and minute between two datatime sql
Sql :: get monday of current week sql
Sql :: combine two columns using sql query

Search

SQL

alter sequence set current value oracle

ADD CONTENT