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;