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:
- How do I get the first letter in uppercase in Oracle SQL?
- Oracle CHR Function
- String to Uppercase in Oracle