LOWER

=LOWER=

Syntax
LOWER(char)

Definition:
When you change all letters to lower case or Returns character string in lowercase

Examples:
SELECT LOWER (last_name)||LOWER(SUBSTR(first_name,1,2)) from f_staffs SELECT LOWER (last_name)||LOWER(SUBSTR(first_name,1,5)) from employees
 * LOWER(LAST_NAME) || LOWER(SUBSTR(FIRST_NAME,1,2)) ||
 * doesu ||
 * LOWER(LAST_NAME) || LOWER(SUBSTR(FIRST_NAME,1,5)) ||
 * doesue ||

SELECT LOWER (last_name)||LOWER(SUBSTR(first_name,1,1)) from f_staffs
 * LOWER (last_name) || LOWER(SUBSTR(first_name,1,1)) ||
 * does ||