Oracle - PL/SQL - CHR Function

In Oracle/PLSQL, the chr function is the opposite of the ascii function. It returns the character based on the NUMBER code.

The syntax for the chr function is:

chr( number_code )

number_code is the NUMBER code used to retrieve the character.

Applies To:

  • Oracle 8i, Oracle 9i, Oracle 10g, Oracle 11g

For example:

chr(116);

would return 't'.

chr(84);

would return 'T'.