drop table book;
create table book(id number(10),a varchar2(10), primary key(id));
drop sequence clientaudit_seq;
create sequence clientaudit_seq start with 1 increment by 1;
create or replace trigger clientaudit_trigger
before insert on book
for each row
begin
select clientaudit_seq.nextval into :new.id from dual;
end;
insert into book (a) values ('aa');
insert into book (a) values ('bb');
commit;
select * from book;