SELECT INITCAP(‘hello world‘) as "首字母大写" FROM DUAL; SELECT UPPER(‘hello world‘) as "全部转为大写" FROM dual; SELECT LOWER(‘HELLO WORLD‘) as "全部转为小写" FROM DUAL;
ORACLE 字符串大小写转换
原文:https://www.cnblogs.com/coldstream/p/12072939.html