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
commit
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