create or replace trigger "BI_STDT_TASKS" before insert on "STDT_TASKS" for each row begin if :NEW."TASK_ID" is null then select "STDT_TASKS_SEQ".nextval into :NEW."TASK_ID" from sys.dual; end if; end; /