oracle如何设置序列自动增长
oracle如何设置序列自动增长droptable book;--创建表createtable book(bookId varchar2(4) primarykey,name varchar2(20));--创建序列createsequence book_seq start with 1 increment by 1;--创建触发器createorreplacetrigger book_triggerbefore inserton bookfor each rowbeginselect book_seq.nextval into :new.bookId from dual;end ;--添加数据insertinto book(name) values ('cc');insertinto book(name) values ('dd');commit;