CREATE OR REPLACE TRIGGER CASIC_USERROLETESTIT
BEFORE INSERT ON CASIC_USERROLETEST
FOR EACH ROW

when (NEW.ID IS NULL)
BEGIN
    SELECT CASIC_USERROLETESTIS.NEXTVAL INTO:NEW.ID FROM DUAL;
    END;