ORACLE LOWER FUNCTION

LOWER function in oracle converts all the input characters in LOWER case.

Syntax :-

SELECT LOWER(INPUT STRING) FROM DUAL;

Example:-

SELECT LOWER('CHANCHAL WANKHADE') as LOWER_exaple from dual;

Result:-  chanchal wankhade



Read Also:- LOWER function in SQL