Home » SQL » Convert to Lowercase in Oracle SQL

Convert to Lowercase in Oracle SQL

By

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

Lower() Syntax

lower(string)

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;

Output:

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:

declare
   v_string varchar2(100);
begin
   v_string := lower('This is a STRING.');
   dbms_output.put_Line(v_string);
end;

Output

this is a string.

See also: