| NLS_CHARSET_DECL_LEN |
|
Returns the declaration length (in number of characters) of an NCHAR column
|
NLS_CHARSET_DECL_LEN(<byte_count>, 'character_set_id'>); |
SELECT NLS_CHARSET_DECL_LEN(200, nls_charset_id('ja16eucfixed'))
FROM dual; |
| |
| NLS_CHARSET_ID |
|
Returns the character set ID number corresponding to character set name string |
NLS_CHARSET_ID(<string>) |
SELECT NLS_CHARSET_ID('ja16euc')
FROM dual; |
| |
| NLS_CHARSET_NAME |
| Returns the name of the character set corresponding to ID number number |
NLS_CHARSET_NAME(<number>); |
SELECT NLS_CHARSET_NAME(2)
FROM dual; |