Search notes:

Oracle: identity columns - START WITH and INCREMENT BY clauses

When defining an Identity column, the start with and/or increment by options can be used to control with what number the generated numbers should begin or in what intervals they should increase.
create table tq84_identity (
  id   number generated as identity start with 10 increment by 3 primary key,
  txt  varchar2(10)
);


insert into tq84_identity(txt) values ('ten'     );
insert into tq84_identity(txt) values ('thirteen');
insert into tq84_identity(txt) values ('sixtenn' );

select * from tq84_identity;

drop table tq84_identity purge;
Github repository Oracle-Patterns, path: /DatabaseObjects/Tables/12c/identity_start_with.sql

Index