| NLS_CHARSET_DECL_LEN |
| Returns the declaration length (in number of characters) of an NCHAR column |
NLS_CHARSET_DECL_LEN(bytecnt IN NUMBER,
csetid IN NUMBER) RETURN PLS_INTEGER; |
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(csetname IN VARCHAR2)
RETURN PLS_INTEGER; |
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(csetid IN PLS_INTEGER)
RETURN VARCHAR2; |
SELECT NLS_CHARSET_NAME(2)
FROM dual; |