Hello,

I am trying to use a pre_insert trigger with my oracle db:-

create table book(
id number,
name varchar2(100)
);



CREATE OR REPLACE TRIGGER book_ins
BEFORE INSERT ON book FOR EACH ROW
BEGIN
SELECT book_seq.NEXTVAL
INTO :new.id
from DUAL;
END;

Does anyone know if this is correct?