创建sequence实现主键id自增

create table t_book(
  id number(20) primary key not null,
  bookName varchar(30),
  price float(33),
  author varchar(22),
  bookTypeId varchar(22)
)
drop table t_book
select t.*,t.rowid  from t_book t
delete from t_book where id=1

create sequence book_seq  increment by 1 start with 1 nomaxvalue nocache;              //nocache不使用缓存    nomaxvalue无最大值

insert into book values(book_seq.nextval,?,?,?)

参考

drop sequence root;




commit