SQL> select REGEXP_REPLACE(INITCAP('abc_de_fghijkl_mn'), '(\w)[_]', '\1')
2 from dual
3 /
REGEXP_REPLACE(INITCAP('ABC_DE
------------------------------
AbcDeFghijklMn
有搞xml的知道这是干嘛的,嘿嘿
SQL> select REGEXP_REPLACE(INITCAP('abc_de_fghijkl_mn'), '(\w)[_]', '\1')
2 from dual
3 /
REGEXP_REPLACE(INITCAP('ABC_DE
------------------------------
AbcDeFghijklMn