oracle:设置自动增长列



1。指定主键

create table bars

(bar_id int not null, constraint bar_pk primary key (bar_id) references bar(bar_id));

2。创建sequence

create sequence bar_seq start with 1;

3。创建trigger

create or replace trigger bar_tri

before insert on bars

for each row

begin

select bar_seq.NEXTVAL

into :new.bar_id

from dual;

end;