ORACLE 字母大小写转换函数

SELECT INITCAP('hello world') as "将首字母转换为大写"  FROM DUAL;
 
SELECT UPPER('hello world')   as "全部转为大写" FROM dual;
 
SELECT LOWER('HELLO WORLD')   as "全部转为小写" FROM DUAL;


版权声明:本文为lotusyangjun原创文章,遵循CC 4.0 BY-SA版权协议,转载请附上原文出处链接和本声明。