Oracle关于表主键自增触发器的实现

例表：Users

create table Users(

       id number,

       urname varchar2(50),

       sex varchar2(50),

       birthday date,

       address varchar2(50)

)

创建sequence users_s，设置自增从1开始，+1

create sequence users_s start with 1 increment by 1 nomaxvalue nominvalue nocache

创建触发器，对每一行设置 id : users_s.nextval ​ 从dual表中

create or replace trigger tr_user

before insert on users 

for each row 

begin

select users_s.nextval into :new.id from dual;

end;

​插入数据，无需插入id 

insert into Users(urname,sex,Birthday,Address) values('B','M',to_date('2004-2-11','YYYY-MM-DD'),'asd')

​select * from Users