Oracle/PLSQL: CHR Function
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 )
Parameters or Arguments
number_code is the NUMBER code used to retrieve the character.
The CHR function can be used in the following versions of Oracle/PLSQL:
- Oracle 12c, Oracle 11g, Oracle 10g, Oracle 9i, Oracle 8i
Let's look at some Oracle CHR function examples and explore how you would use the CHR function in Oracle/PLSQL.
|CHR(116)||would return 't'|
|CHR(84)||would return 'T'|