CHR function in Oracle

CHR is another vital string/char functions of Oracle. It is used to return the actual character or symbol for the desired ASCII code. The CHR function is supported in the various versions of the Oracle/PLSQL, including, Oracle 12c, Oracle 11g, Oracle 10g, Oracle 9i and Oracle 8i.


CHR( code )

code: It is used to specify the code, for which the actual character or symbol needs to be retrieved.

Example 1:

CHR( 97 )



The ASCII code of ‘a’ is 97 and so is the result.

Please Share