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