Oracle NLS_LOWER function
Description
The Oracle NLS_LOWER() function returns a specified character expression in lowercase letters.
Note: National Language Support (NLS) is a technology enabling Oracle applications to interact with users in their native language, using their conventions for displaying data.
Syntax:
NLS_LOWER(string1 [, 'nlsparam' ])
Parameters:
Name | Description | Data Types |
---|---|---|
string1 | A string whose first character in each word will be converted to uppercase and the rest characters will be converted to lowercase. | CHAR, VARCHAR2, NCHAR, NVARCHAR2, CLOB, or NCLOB |
nlsparam | The value of 'nlsparam' can have this form : 'NLS_SORT = sort' where sort is either a linguistic sort sequence or BINARY. The linguistic sort sequence handles special linguistic requirements for case conversions. These requirements can result in a return value of a different length than the char. If you omit 'nlsparam', then this function uses the default sort sequence for your session. |
Return Value Type:
CHAR, VARCHAR2, NCHAR, NVARCHAR2, CLOB, or NCLOB
Examples: Oracle NLS_LOWER function
The following statement returns the lowercase form of the character string 'W3RESOURCE'.
SQL> SELECT NLS_LOWER('W3RESOURCE') "Lowercase" FROM DUAL; Lowercase ---------- w3resource
Previous:
NLS_INITCAP
Next:
NLS_UPPER
- Weekly Trends
- Java Basic Programming Exercises
- SQL Subqueries
- Adventureworks Database Exercises
- C# Sharp Basic Exercises
- SQL COUNT() with distinct
- JavaScript String Exercises
- JavaScript HTML Form Validation
- Java Collection Exercises
- SQL COUNT() function
- SQL Inner Join
- JavaScript functions Exercises
- Python Tutorial
- Python Array Exercises
- SQL Cross Join
- C# Sharp Array Exercises