Oracle Database 19c Enterprise Edition Release 19.0.0.0.0 - Production
I'm looking for strings with any number of letters followed by a point and at least one lowercase letter.
The sample is not like this ( 'H.T. Al' -there is a capital letter after the first point, and a space after the second ), but the first select indicates a hit. Why?
select 'XX' from dual where regexp_like ( 'H.T. Al','[A-Za-z]*\.[a-z]+' ,'c') ; The result: XX
If I replace 'T' with 'A', the result is null. This is total nonsense:
select 'XX' from dual where regexp_like ( 'H.A. Al','[A-Za-z]*\.[a-z]+','c' ) ; The result: null
select 'XX' from dual where regexp_like ( 'H.T. Al','[A-Za-z]*\.[[:lower:]]+','c' ) ; The result: null