Oracle LOWER function
Description
The Oracle LOWER() function returns a specified character expression in lowercase letters.
Syntax:
LOWER(cExpression)
Parameters:
Name | Description | Data Types |
---|---|---|
cExpression | The given character expression. | CHAR, VARCHAR2, NCHAR, NVARCHAR2, CLOB, or NCLOB |
Return Value Type
CHAR, VARCHAR2, NCHAR, NVARCHAR2, CLOB, or NCLOB
Note: For linguistic-sensitive uppercase and lowercase, refer to NLS_INITCAP.
Applies to
Oracle 12c, Oracle 11g, Oracle 10g, Oracle 9i, Oracle 8i
Pictorial Presentation
Examples: Oracle LOWER function
The following example returns the first name of the employees in lower case.
Sample table: employees
SQL> SELECT LOWER(first_name) FROM employees;
Output :
LOWER(FIRST_NAME) -------------------- ellen sundar mozhe david hermann shelli amit elizabeth sarah david ......
- New Content published on w3resource:
- HTML-CSS Practical: Exercises, Practice, Solution
- Java Regular Expression: Exercises, Practice, Solution
- Scala Programming Exercises, Practice, Solution
- Python Itertools exercises
- Python Numpy exercises
- Python GeoPy Package exercises
- Python Pandas exercises
- Python nltk exercises
- Python BeautifulSoup exercises
- Form Template
- Composer - PHP Package Manager
- PHPUnit - PHP Testing
- Laravel - PHP Framework
- Angular - JavaScript Framework
- Vue - JavaScript Framework
- Jest - JavaScript Testing Framework