Oracle/SQL LOWER Function

Oracle LOWER FunctionSQL LOWER Function is used to convert the letters/alphabets of a string to lower case. Oracle LOWER Function converts all the letters/alphabets of the passed string to lower case.


SQL LOWER Function Syntax

SELECT LOWER(string)
FROM table_name;

In the above Oracle LOWER Function Syntax:-
string is the string whose letters will be converted to lower case.


SQL LOWER Function – Using SQL SELECT Statement Examples

SQL LOWER Function is used with the SQL SELECT Statement.

For example, the Oracle LOWER Function query returns the letters of words in lower case.

SELECT LOWER('Tech Honey') "Oracle LOWER"
FROM dual;

Will return ‘tech honey’

Note: We have aliased LOWER(‘Tech Honey’) as Oracle LOWER.


SQL LOWER Function – Using Upper Case Word Example

SQL LOWER Function can convert a word from UPPER to LOWER case.

For example, the below Oracle LOWER Function query returns the lower case version of the upper case word passed.

SELECT LOWER('TECH HONEY') "Oracle/SQL LOWER Function"
FROM dual;

Will return ‘tech honey’

Note: We have aliased LOWER(‘TECH HONEY’) as Oracle/SQL LOWER Function.


SQL LOWER Function – Using any format of Word Example

Oracle LOWER Function returns all the alphabets in lower case.

For example, the below Oracle LOWER Function query returns all the letters in lower case irrespective of original case of letters.

SELECT LOWER('TECh HOney')
FROM dual;

Will return ‘tech honey’.

Note: We have aliased LOWER(‘TECh HOney’) as “Oracle/SQL LOWER Function”.


Leave a Reply

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