例表: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