ORACLE 字符串大小写转换
SELECT INITCAP('hello world') as "首字母大写"  FROM DUAL;

SELECT UPPER('hello world')   as "全部转为大写" FROM dual;

SELECT LOWER('HELLO WORLD')   as "全部转为小写" FROM DUAL;
posted on 2019-12-20 14:31  冷月*清风  阅读(6782)  评论(0)    收藏  举报