|Oracle® Database SQL Reference 10g Release 1 (10.1) Part Number
B10759-01 CHR returns the character having the binary equivalent
to n as a VARCHAR2 value in either the database character set
or, if you specify NCHAR_CS, the national character set. For
single-byte character sets, if n > 256, then Oracle Database
returns the binary equivalent of n mod 256. For multibyte
character sets, n must resolve to one entire code point. Invalid
code points are not validated, and the result of specifying
invalid code points is indeterminate. This function takes as an
argument a NUMBER value, or any value that can be implicitly
converted to NUMBER, and returns a character. Note:Use of the
The following example is run on an ASCII-based machine with the
database character set defined as WE8ISO8859P1: SELECT
CHR(67)||CHR(65)||CHR(84) "Dog" FROM DUAL; Dog --- CAT To
produce the same results on an EBCDIC-based machine with the
WE8EBCDIC1047 character set, the preceding example would have to
be modified as follows: SELECT CHR(19