SELECT INITCAP('hello world') as "首字母大写" FROM DUAL;
SELECT UPPER('hello world') as "全部转为大写" FROM dual;
SELECT LOWER('HELLO WORLD') as "全部转为小写" FROM DUAL;
Oracle字符串大小写转换
最新推荐文章于 2024-01-14 21:03:03 发布
SELECT INITCAP('hello world') as "首字母大写" FROM DUAL;
SELECT UPPER('hello world') as "全部转为大写" FROM dual;
SELECT LOWER('HELLO WORLD') as "全部转为小写" FROM DUAL;