oracle 实现主键id自增

1、新建表

create table LINEMATERIAL
(
id int not null,
name varchar2(20),
linetype varchar2(100)
)

添加表注释、字段注释

comment on table LINEMATERIAL is '测试表 稍后会删除'
comment on column LINEMATERIAL.name is '姓名'
comment on column LINEMATERIAL.linetype is '性别'

2、创建序列

CREATE SEQUENCE LINEMATERIAL_ID // EMP 表ID 作为自增序列
    INCREMENT BY 1  //每次增值1
    MINVALUE 1 //自增字段最小值
    NOMAXVALUE    //最大值 MAXVALUE 9999999999999999
    START WITH 1 //起始值
    NOCACHE     //不缓存  CACHE 20

3、创建触发器

create or replace trigger LINEMATERIAL_TG_INSERT_ID
before insert on LINEMATERIAL for each row
begin
select LINEMATERIAL_ID.nextval into:new.id from dual;
end;

4、测试 插入两条数据

insert into LINEMATERIAL(name,linetype) values (‘name1’,‘linetype’);
insert into LINEMATERIAL(name,linetype) values (‘name2’,‘linetype’);

参考来源:
Oracle实现主键自增的几种方式.
Oracle实现主键自增.