Convert to Lowercase in Oracle SQL

You can use the lower() function to convert a string to lowercase in Oracle SQL.

Lower() Syntax


Changing all letters of a string to lowercase Using SQL query

The following SQL query will convert the string to lowercase.

select lower('This is a STRING.') from Dual;


this is a string.

Using Lower() Function in WHERE Clause

select * from Emp where lower(ename) = 'king'

The above SQL query will return the records from the EMP table where the lower ENAME is equal to 'king'.

Lower() Function in PL/SQL Program

The following PL/SQL program assigns a string value by converting it to lowercase using the lower() function and prints on the screen:

   v_string varchar2(100);
   v_string := lower('This is a STRING.');


this is a string.

See also:

Written by Rony Dsouza

Rony is an Oracle programmer, having more than 15 years of experience. He likes to write on SQL, PL/SQL, and Oracle Apex topics. Also, expertise in Python, PHP, MySQL, JavaScript, etc.

Leave a Reply

Your email address will not be published. Required fields are marked *