oracle自动生成主键id
1:创建user1表:
create table user1(
id number,
name varchar(20));
2:创建sequence(user1_seq):
create sequence user1_seq
minvalue 1
maxvalue 999999
start with 1
increment by 1
cache 20;
3:创建触发器:
create or replace trigger user1_tig
before insert on user1 for each row
begin
select to_char(user1_seq.nextval) into :new.id from dual;
end user1_tig;
/
OK,到此就完成啦,试一下:
insert into user1(name)values('aa');
它会自动添加id的