在Oracle上基于序列和触发器实现主键自增长

在Oracle下基于序列和触发器实现主键自增长

drop?table?book;
drop?sequence?book_seq;
drop?trigger?book_tri;
--创建表格
create?table?book
(
bookId?integer?primary?key?not?null,
bookName?varchar2(20),
price?number(3)
)tablespace?zfs_data
desc??book;
--创建序列
--创建一个从10000开始每次递增为1的序列
create?sequence?book_seq?minvalue?10000?maxvalue?9999999?increment?by?1?start?with?10000?;
--创建一个触发器,用于每次插入前自动成成序列的值
create?or?replace?trigger?book_tri
??before?insert?on?book?for?each?row
??begin
????select?book_seq.nextval?into?:new.bookId?from?dual;
??end;
/??
commit;??

insert?into?book?(bookName,?price)?values('深入浅出EXTJS',59);
insert?into?book?(bookName,?price)?values('深入浅出Jquery',49);

select?*?from?book;