Hi,
I wan't to convert a string "bygger'n" to "Bygger'n", is it possible to do something like this with regexp_replace?
"bygger'n" is just meant as an example, I want to replace all matching patterns with lowercase letters.
Oracle does not seem to consider lower/upper-functions for the replace of patterns:
SQL> select regexp_replace(initcap('bygger''n'), '(''[[:alnum:]])', lower('\1')) try_lower
2 , regexp_replace(initcap('bygger''n'), '(''[[:alnum:]])', ' \1 ') spaces
3 from dual
4 /
TRY_LOWE SPACES
-------- ----------
Bygger'N Bygger 'N
Regards
Haavard