CHR Function

CHR

The CHR function will return the character having the binary equivalent to the string in either the database character set or the national character set. The function returns the high level language character from ASCII value.
Syntax: chr (number)

Ex:

 select chr(97),chr(65) from dual;

output

chr(97)
--------
a
chr(65)
----------
A
CHR Function in SQL
CHR Function in SQL

Leave a Reply