--创建序列
create sequence book_seq start with 1 INCREMENT by 1;
--创建触发器
create or replace TRIGGER book_trigger
before INSERT on BOOK
for each row
begin
SELECT book_seq.nextval into :new.BOOKID from dual;
end;
--创建序列
create sequence book_seq start with 1 INCREMENT by 1;
--创建触发器
create or replace TRIGGER book_trigger
before INSERT on BOOK
for each row
begin
SELECT book_seq.nextval into :new.BOOKID from dual;
end;