oracle通过序列和触发器实现自增主键

创建表

CREATE table user_tr(

  id int primary key,
  name varchar2(10),
  gender varchar2(2),
  phone number(11),
  address varchar(20)
)

创建表的序列

create sequence seq_user
  start with 1
  increment by 1
  nocache;

 

创建触发器

create or replace trigger tr_user
  before insert on user_tr
  for each row when(new.id is null)
  begin
    select user_seq.nextval into:new.id from dual;
  end;

通过插入数据测试成功

insert into user_tr(name,gender,phone,address) values('刘能','男',13071519901,'象牙山');
insert into user_tr(name,gender,phone,address) values('赵四','男',13074519901,'黄山');
insert into user_tr(name,gender,phone,address) values('香秀','女',13074519901,'观音山');
insert into user_tr(name,gender,phone,address) values('小刘能','女',13071514961,'普陀山');
insert into user_tr(name,gender,phone,address) values('刘大能','男',13071514451,'峨眉山');