Oracle Insert trigger

[nirajbpate]

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?

[tkarikal]

for the script side is everything perfect..

First time before insert into that particular table "book" table is created. next time before insert , the trigger fires to create the "book" once again.the database wont allow u to creat database object with same names..