Thursday, January 10, 2013

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'