CREATE OR REPLACE TRIGGER CASIC_USERSTATUSIT
BEFORE INSERT ON CASIC_USERSTATUS
FOR EACH ROW

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