Oracle NLS_CHARSET_NAME function
Description
The Oracle NLS_CHARSET_NAME is used to return the name of the character set corresponding to ID number number1. When the number is not recognized as a valid character set ID, then this function returns null.
Syntax:
NLS_CHARSET_NAME(number1)
Parameter:
| Name | Description |
|---|---|
| number1 | A number |
Return Value Type
VARCHAR2
Examples: Oracle NLS_CHARSET_NAME function
The following example returns the character set corresponding to character set ID number 1:
SELECT NLS_CHARSET_NAME(1)
FROM DUAL;
Sample Output:
NLS_CHAR -------- US7ASCII
Previous:
NLS_CHARSET_ID
Next:
Oracle JOINS
- 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