Hi
If I call below query in other NLS_LANG i have different results.
alter session set NLS_LANGUAGE=ENGLISH;
select lower(regexp_replace(regexp_replace('path', '([A-Z])([A-Z][a-z])', '\1-\2', 1, 0, 'c'),'([a-z])([A-Z])', '\1-\2', 1, 0, 'c')) from dual;
LOWER
----
path
alter session set NLS_LANGUAGE=POLISH;
select lower(regexp_replace( regexp_replace('path', '([A-Z])([A-Z][a-z])', '\1-\2', 1, 0, 'c'), '([a-z])([A-Z])', '\1-\2', 1, 0, 'c')) from dual;
LOWER
------
p-a-th
If I run these queries on Oracle 11g have proper results (the same) in POLISH and ENGLISH as well. Is it some bug ?