Oracle PL/SQL Lower Function

The Lower function converts all letters in the specified string to lowercase.

The Lower Function syntax:

lower( string )

Example:

select lower('Learn Oracle Lesson') from dual;

learn oracle lesson


select lower('ORACLE 10G') from dual;

oracle 10g