NLS_CHARSET_NAME
NLS_CHARSET_NAME
returns the name of the character set corresponding to the character set ID number.
SQL syntax
NLS_CHARSET_NAME(Number)
Parameters
NLS_CHARSET_NAME
has the parameter:
Parameter | Description |
---|---|
|
The number represents a character set ID. If the number does not correspond to a supported TimesTen character set ID, |
Description
The character set name is returned as a VARCHAR2
value in the database character set.
Examples
The following example returns the database character set corresponding to character set ID number 1:
Command> SELECT nls_charset_name(1) FROM dual; < US7ASCII > 1 row found.
The following example gets the same result, determining the name of the database character set by providing CHAR_CS
as the character set name within the NLS_CHARSET_ID
function, whose results are provided to the NLS_CHARSET_NAME
function:
SELECT NLS_CHARSET_NAME(NLS_CHARSET_ID('CHAR_CS')) FROM dual; < US7ASCII > 1 row found.
See the previous section, "NLS_CHARSET_ID" for related information.