Oracle主键自增

发表于 | 分类于
Oracle主键自增

利用SEQUENCE和触发器

例如：表名:TBOOK 主键名:BOOKID

创建序列

1
create sequence SEQ_BOOK increment by 1 start with 1 maxvalue 999999999;

创建触发器实现主键自增 

1
2
3
4
5
6
create or replace trigger TBOOK_TRIGGER       
before insert on TBOOK       
for each row       
begin       
select SEQ_BOOK.nextval into :new.BOOKID from dual;      
end;