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.

Syntax

The syntax for the chr function is:

chr( number_code )

number_code is the NUMBER code used to retrieve the character.

Applies To

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

For Example

chr(116);	would return 't'
chr(84);	would return 'T'

select chr(18) from dual;