Convert all the characters of the string to the lower case
By Santhosh N
This explains how to convert all the characters to the lower case alphabets
Oracle has a function by the name, LOWER used to convert the string characters to
the lower case alphabets.
Syntax: LOWER(str)
Ex1: LOWER(‘EGG’)
This returns ‘egg’ as the result.
Ex2: LOWER(‘EggHead’)
This returns ‘egghead’ as the result
Note: While comparing the values from other source with the values in the columns using
LIKE, LOWER can be used to compare irrespective of the case sensitivity.
Related FAQs
This explains how to find the length of the string in oracle
This explains how to convert first character of the word to the upper case and rest to the lower case.
This explains how to get the character of the desired Ascii code in oracle.
This explains how to convert any character set strings to ascii character set strings in oracle.
This explains how to get the ascii code of the desired character in oracle.
Convert all the characters of the string to the lower case (1308 Views)