Oracle String/Char Function - Oracle/PLSQL CHR Function






This Oracle tutorial explains how to use the Oracle/PLSQL CHR function.

CHR(x) gets the character with the ASCII value of x.

CHR() and ASCII() have the opposite effect.

Syntax

The syntax for the Oracle/PLSQL CHR function is:

CHR( number_code )

number_code is the NUMBER code used to get the character.

Example


SQL> SELECT CHR(97), CHR(65) FROM dual;

C C
- -
a A

SQL>