oracle下划线转驼峰
select substr(replace(initcap('a' || 't_sys_user'), '_', ''), 2) from dual;
驼峰转下划线
select regexp_replace('tSysUser', '([[:upper:]])(.)', '_\1\2') "initCustMoney",
regexp_replace('userId', '([[:upper:]])(.)', '_\1\2') "custID"
from dual;
2022-03-31 11:27:46
oracle下划线转驼峰
select substr(replace(initcap('a' || 't_sys_user'), '_', ''), 2) from dual;
驼峰转下划线
select regexp_replace('tSysUser', '([[:upper:]])(.)', '_\1\2') "initCustMoney",
regexp_replace('userId', '([[:upper:]])(.)', '_\1\2') "custID"
from dual;
下一篇:oracle常用字符函数