SQL LOWER() Function

SQL LOWER() function return lowercase character in every word.

SQL LOWER() function supported Oracle SQL version

  • Oracle 8i
  • Oracle 9i
  • Oracle 10g
  • Oracle 11g
  • Oracle 12c
  • Oracle 18c

Syntax

LOWER(char/string)

Example

Consider following example return the lowercase string of given string argument.

SQL> SELECT LOWER('Opal KOLE') "LOWER" FROM DUAL;

LOWER
---------
opal kole