oracle主键自增

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

利用SEQUENCE和触发器

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

  • 创建序列
1
create sequence SEQ_BOOK increment by 1 start with 1 maxvalue 999999999;
  • 创建触发器实现主键自增 
create or replace trigger TBOOK_TRIGGER       
before insert on TBOOK       
for each row       
begin       
select SEQ_BOOK.nextval into :new.BOOKID from dual;      
end;