oracle常用函数

lower()将字符串全部转换为小写

    如：

SQL> select lower('HELLO Roger,WELCOME TO HEBUTI') result from dual;

RESULT
-----------------------------
hello roger,welcome to hebuti

 

upper()将字符串全部转换为大写

    如：

SQL> select upper('HELLO Roger,WELCOME TO HEBUTI') result from dual;

RESULT
-----------------------------
HELLO ROGER,WELCOME TO HEBUTI

 

initcap()将字符串中所有单词的首字母转换成大写。

    如：

SQL> select initcap('HELLO Roger,WELCOME TO HEBUTI') result from dual;

RESULT
-----------------------------
Hello Roger,Welcome To Hebuti