The LOWER (lower case) function returns char, with all letters lowercase. char can be any of the datatypes CHAR, VARCHAR2, NCHAR, NVARCHAR2, CLOB, or NCLOB. The return value is the same datatype as char. This can be used with the INITCAP function to change all upper case names to lower case and then set the first letter of the name to capitals before it is used.Syntax >ÄÄLOWERÄÄ(char)ÄÄ><PL/SQL Example LOWER ('BIG FAT LETTERS') ==> 'big fat letters' LOWER ('123ABC') ==> '123abc' SQL Example The following example returns a string in lowercase:SELECT LOWER('MR. SCOTT MCMILLAN') "Lowercase" FROM DUAL; Lowercase -------------------- mr. scott mcmillan
>ÄÄLOWERÄÄ(char)ÄÄ><PL/SQL Example
LOWER ('BIG FAT LETTERS') ==> 'big fat letters'
LOWER ('123ABC') ==> '123abc'
SQL Example
The following example returns a string in lowercase:SELECT LOWER('MR. SCOTT MCMILLAN') "Lowercase"
FROM DUAL;
Lowercase
--------------------
mr. scott mcmillan
全大写 UPPER('aBc') 结果 ABC