[Oracle] LOWER()

오라클 LOWER()

 

LOWER()

   - 문자열을 소문자로 바꿔주는 함수

 

LOWER(char)

의 형태

 

LOWER returns char, with all letters lowercase. char can be any of the data types CHAR, VARCHAR2, NCHAR, NVARCHAR2, CLOB  or NCLOB. The return value is the same data type as char. The database sets the case of the chracters based on the binary mapping defined for the underlying character set. For linguistic-sensitive lowercase, refer to NLS_LOWER.

 

SQL > SELECT LOWER('MR. SCOTT') FROM DUAL ;

   --> mr. scott