Oracle SQL: the Essential Reference

NLS_CHARSET_DECL_LEN

NLS_CHARSET_DECL_LEN(bytecnt, csid)

Returns the declaration width of an NCHAR column (in terms of the number of characters), based on the byte count provided.

Parameters

bytecnt

Specifies the size, in bytes, of the NCHAR column.

csid

Specifies a number identifying the NLS character set you use for the column. You can use the NLS_CHARSET_ID function to get the character set number to correspond to a character set name.

Example

SQL> SELECT NLS_CHARSET_DECL_LEN(100,NLS_CHARSET_ID('US7ASCII'))
  2  FROM dual;

NLS_CHARSET_DECL_LEN(100,NLS_CHARSET_ID('US7ASCII'))
----------------------------------------------------
                                                 100