oracle主键自增

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;