Definition: The Oracle CHR() function returns the ASCII character that corresponds to the value passed to it. If using NCHAR_CS is specified, it returns the character that corresponds to the national character set.

Example Syntax:

CHR(number);

CHR(number) using nchar_cs;

Example Usage:

CHR(65);

The example above returns the letter "A", which is the ASCII character representation of the number 65.
Related Links: