CHR

CHR converts an integer to the character with its binary equivalent in either the database character set or the national character set.

For single-byte character sets, if n > 256, then CHR returns the binary equivalent of n mod 256. For multibyte character sets, n must resolve to one entire code point. Code points are not validated, and the result of specifying invalid code points is indeterminate.

Return Value

VARCHAR2 | NVARCHAR2

Syntax

CHR(n [ USING NCHAR_CS ])

Arguments

n is a numeric expression.

USING NCHAR_CS returns a character in the national character set. Otherwise, the return value is in the database character set.

Example

CHR(67) returns the letter C on an ASCII-based system with the WE8ISO8859P1 database character set.