去掉下划线并转首字母为大写
[sql]
SQL> select REGEXP_REPLACE(INITCAP('abc_de_fghijkl_mn'), '(\w)[_]', '\1')
2 from dual
3 /
REGEXP_REPLACE(INITCAP('ABC_DE
------------------------------
AbcDeFghijklMn
[sql]
SQL> select REGEXP_REPLACE(INITCAP('abc_de_fghijkl_mn'), '(\w)[_]', '\1')
2 from dual
3 /
REGEXP_REPLACE(INITCAP('ABC_DE
------------------------------
AbcDeFghijklMn