Oracle® OLAP DML Reference 11g Release 2 (11.2) Part Number E17122-07 |
|
|
PDF · Mobi · ePub |
The CHR function converts an integer value (or any value that can be implicitly converted to an integer value) into a character.
Note:
Use of this function results in code that is not portable between ASCII- and EBCDIC-based architectures.A text value. For single-byte character sets, if number
> 256
, the function returns the binary equivalent of number
MOD 256
. For multibyte character sets, number
must resolve to one entire code point. Invalid code points are not validated, and the result of specifying invalid code points is indeterminate.
CHR(number [ USING NCHAR_CS ])
An integer value, or any value that can be implicitly converted to an integer value.
Specifies that the function returns the value in the national character set. When you do not specify this clause, the function returns the value in the database character set.