Trigger UDX_PASSWORD_UPDATE

CREATE OR REPLACE TRIGGER UDX_PASSWORD_UPDATE
BEFORE UPDATE OF CFSTRING1 ON ABPGRPCUSTOMFIELDV
FOR EACH ROW
BEGIN

   IF :NEW.CFSTRING2 IS NULL OR :OLD.CFSTRING1 != :NEW.CFSTRING1 THEN
      :NEW.CFSTRING2 := DBMS_RANDOM.STRING('x', 8);
   END IF;
END;