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版权协议,转载请附上原文出处链接和本声明。
SELECT INITCAP('hello world') as "将首字母转换为大写" FROM DUAL;
SELECT UPPER('hello world') as "全部转为大写" FROM dual;
SELECT LOWER('HELLO WORLD') as "全部转为小写" FROM DUAL;