Oracle/PLSQL: 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'.

View a listing of the ascii values.