Oracle NLS_CHARSET_NAME function

Last update on August 19 2022 21:51:21 (UTC/GMT +8 hours)

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