NLS_CHARSET_NAME

Syntax

Purpose

NLS_CHARSET_NAME returns the name of the NLS character set corresponding to ID number n. The character set name is returned as a VARCHAR2 value in the database character set.

If n is not recognized as a valid character set ID, this function returns null.

Example

SELECT NLS_CHARSET_NAME(2)
  FROM DUAL;

NLS_CH 
------ 
WE8DEC

See Also: Oracle8i National Language Support Guide for a list of character set IDs.