w3resource

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



Share this Tutorial / Exercise on : Facebook and Twitter