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