Oracle SQL - Function LOWER function

  1. HOME
  2. Oracle SQL
  3. Function
  4. LOWER function

Introduction

LOWER function converts every letter of a string to lower-case.

The general format for this function is: 

LOWER(string)

Demo

SQL>
SQL>-- w ww . ja va 2 s.co  m
SQL> SELECT LOWER('Test') FROM dual
  2