Learn how to use the Oracle/PLSQL CHR function with syntax and examples.
The Oracle/PLSQL CHR function is the opposite of the ASCII function. It returns the character based on the NUMBER code.
The syntax for the Oracle/PLSQL CHR function is:
CHR( number_code )
number_code is the NUMBER code used to retrieve the character.
The CHR function can be used in the following versions of Oracle/PLSQL:
Let's look at some Oracle CHR function examples and explore how to use the CHR function in Oracle/PLSQL.
CHR(116) Result: 't' CHR(84) Result: 'T'