Tuesday, April 27, 2010

CHR in Oracle

The CHR function converts an integer value (or any value that can be implicitly converted to an integer value) into a character.

Return Value

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.

Syntax

CHR(number [ USING NCHAR_CS ])


number

An integer value, or any value that can be implicitly converted to an integer value.