Oracle NLS_UPPER function
Description
The NLS_UPPER function is used to return all letters of a given string in uppercase.
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_UPPER(string1 [, 'nlsparam' ])
Parameters:
| Name | Description | Data Types |
|---|---|---|
| string1 | A string whose characters will be converted to uppercase. | 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
VARCHAR2
Examples: Oracle NLS_UPPER function
The following example returns a string with all the letters converted to uppercase:
SELECT NLS_UPPER('w3resource') "Uppercase"
FROM DUAL;
Sample Output:
Uppercase ---------- W3RESOURCE
- 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
We are closing our Disqus commenting system for some maintenanace issues. You may write to us at reach[at]yahoo[dot]com or visit us at Facebook