password verify function to avoid repetitive characters in a new password

User_6CB7J

Hello, looking for a function to restrict user from creating a new password with repetitive characters like (aaaaaa) with minimum of two characters only are allowed.

The look currently I am looking at is this one:-

--Check if the password contains repeating characters like "11" or "aa"

    FOR i in 1..m-1 loop

    IF substr(password,i,1)=substr(password,i+1,1) THEN

    raise_application_error(-20000, 'New password may not contain repeating characters');

    END IF;

    END LOOP;

This one is good in not allowing repetitive characters e (like aaOrange123). But we wanted it to allow at least two characters and start not allowing more than two characters.

Frank Kulash

Hi, @User_6CB7J

Regular expressions are good for things like what you want.

REGEXP_LIKE (str, '(.)\1\1')

returns TRUE if (and only if) the string str contains the same character three or more times in a row.

User_6CB7J

https://community.oracle.com/tech/developers/discussion/comment/16839502#Comment_16839502

Thank you so much Frank !!! It seems it worked. I am testing it against all requirements and will update you. I really appreciated your quick help and reply !!!