select regexp_replace('aaa_bbb', '(_.)', upper('\1')) from dual

Question

Using Oracle 11g

select regexp_replace('aaa_bbb', '(_.)', upper('\1')) from dual;

I want 'aaa_Bbb'.

But, it returns 'aaa_bbb'.

Why can't replace?

Answer 1

Upper execute earlier Regexp

select regexp_replace('aaa_bbb', '(_.)', upper(regexp_substr('aaa_bbb', '(_.)'))) from dual