Oracle下使用触发器实现主键ID自增加

1. 建立测试表

create table book(

bookID varchar2(10) primary key,

bookName varchar2(20)

);

2. 创建序列

create sequence book_seq start with 1 increment by 1;

3. 创建触发器

create or replace trigger bookID_auto_trigger

before insert on book for each row

begin

select book_seq.nextval into :new.bookID from dual;

end;

/

4. 测试插入数据

insert into book(bookname) values('Oracle reference');

commit;

select * from book;

bookID           bookName

--------------------------------------------

2                    Oracle reference