Creating an Oracle Sequence Trigger

Question

I am trying to create a seuqunce trigger, but an error occurs when I run the trigger to create sql in SQL Developer. I do not understand, in fact, everything looks good. I share the details below, please help me, thanks.

My sql trigger:

CREATE OR REPLACE TRIGGER "TRIGGER1" BEFORE INSERT ON ACCOUNTS FOR EACH ROW WHEN (new."ID" IS NULL) BEGIN SELECT ACCOUNTS_SEQ.NEXTVAL INTO :new."ID" FROM dual; END; / 

And the error description:

 Error starting at line : 5 in command - CREATE OR REPLACE TRIGGER "TRIGGER1" BEFORE INSERT ON ACCOUNTS FOR EACH ROW WHEN (new."ID" IS NULL) BEGIN SELECT ACCOUNTS_SEQ.NEXTVAL INTO :new."ID" FROM dual Error report - SQL Command: trıgger "TRIGGER1" Failed: Warning: completed with warning Error starting at line : 12 in command - END Error report - Unknown Command 

Answer 1

Try the following:

 CREATE OR REPLACE TRIGGER TRIGGER1 BEFORE INSERT ON ACCOUNTS FOR EACH ROW WHEN (new.ID IS NULL) BEGIN SELECT ACCOUNTS_SEQ.NEXTVAL INTO :new.ID FROM dual; END; / 

Your sequence should look like this

 CREATE OR REPLACE SEQUENCE ACCOUNT_SEQ START WITH 1 INCREMENT BY 1; 

Hope this helps.

Answer 2

 CREATE OR REPLACE TRIGGER TRIGGER1 BEFORE INSERT ON ACCOUNTS FOR EACH ROW BEGIN IF :new.ID IS NULL THEN SELECT ACCOUNTS_SEQ.NEXTVAL INTO :new.ID FROM dual; END IF; END;