oracle主键自增
利用SEQUENCE和触发器
例如：表名:TBOOK 主键名:BOOKID
- 创建序列
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;举报
腾讯云开发者
