Sequence Starts With Value 2 In 11G
(Doc ID 1273858.1)
Last updated on AUGUST 22, 2018
Oracle Database - Enterprise Edition - Version 184.108.40.206 and later
Information in this document applies to any platform.
Newly created sequences start with a value of 2 even if you specify a starting value of 1.
create sequence test_seq
start with 1
create table test_tab(
insert into test_tab values (test_seq.nextval);
select * from test_tab;
To view full details, sign in with your My Oracle Support account.
Don't have a My Oracle Support account? Click to get started!
In this Document
My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.
|This document is being delivered to you via Oracle Support's Rapid Visibility (RaV) process and therefore has not been subject to an independent technical review.|