使用方法:sequence序列化、触发器
插入前表数据:
--sequence序列化
create sequence seq_book_id
minvalue 1
maxvalue 999999
start with 1
increment by 1
cache 50
--设置触发器
create or replace trigger book_id_trigger
before insert on book
referencing old as old new as new for each row
declare
begin
select seq_book_id.nextval into:new.book_id from dual;
end book_id_trigger;
--添加表数据book_name:'了不起的盖茨比',book_price:16
insert into book(book_name,book_price)values('了不起的盖茨比',16);
--查询表数据
select * from BOOK t;
插入后的数据表:
如有问题,请不吝指正