create or replace TRIGGER mark_taskit BEFORE INSERT ON mark_task FOR EACH ROW when (NEW.DBID IS NULL) BEGIN SELECT SEQ_MARK_TASK_ID.NEXTVAL INTO:NEW.DBID FROM DUAL; END;