CREATE OR REPLACE TRIGGER TRI_CASIC_USERRESCTEST
  BEFORE INSERT ON CASIC_USERRESCTEST
  FOR EACH ROW


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