Create a validation of the type ‘Function Returning Boolean’ and add the following code:
##############################
declare
l_return boolean;
begin
if regexp_like(:P120_NEW_PASSWORD, ‘^.*[a-z].*$’) — this is for small letter from a -z
and regexp_like(:P120_NEW_PASSWORD, ‘^.*[A-Z].*$’) — this is for capital letters
and regexp_like(:P120_NEW_PASSWORD, ‘^.*[0-9].*$’) — this is for numbers
and regexp_like(:P120_NEW_PASSWORD, ‘^.*[@!#&$].*$’) — this for other characters, you can add more is you like.
then
l_return :=true;
else
l_return :=false;
end if;
return l_return;
end;
#########################
Enjoy it.