Oracle NLS_INITCAP function
Description
The Oracle NLS_INITCAP() function sets the first letter of each word in uppercase, all other letters in lowercase. Words are delimited by white space or characters that are not alphanumeric.
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_INITCAP(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
This function does not support CLOB data directly. However, CLOBs can be passed in as arguments through implicit data conversion.
Examples: Oracle NLS_INITCAP function
The following examples show how the linguistic sort sequence results in a different return value from the function :
Sample Output:
SQL> SELECT NLS_INITCAP('ijzer') "Initcap" FROM DUAL; Initc ----- Ijzer SQL> SELECT NLS_INITCAP('ijzer', 'NLS_SORT = XDutch') "InitCap" FROM DUAL; InitC ----- IJzer
- Weekly Trends
- Python Interview Questions and Answers: Comprehensive Guide
- Scala Exercises, Practice, Solution
- Kotlin Exercises practice with solution
- MongoDB Exercises, Practice, Solution
- SQL Exercises, Practice, Solution - JOINS
- 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