在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;