CREATE OR REPLACE TRIGGER CASIC_AUDIT_RESULTIT BEFORE INSERT ON CASIC_AUDIT_RESULT FOR EACH ROW when (NEW.DBID IS NULL) BEGIN SELECT CASIC_AUDIT_RESULTIS.NEXTVAL INTO:NEW.DBID FROM DUAL; END;