PL/SQL Chr

The Chr function is the opposite of the ascii function and returns the character based on the number.

Chr syntax

CHR ( number )

Chr example

select chr(65) from dual;

Result: A


select chr(66) from dual;

Result: B


select chr(67) from dual;

Result: C


select chr(65)|| chr(66) || chr(67) from dual;

Result: ABC


select chr(97)|| chr(98) || chr(99) from dual;

Result: abc


select chr(49)|| chr(50) || chr(51) from dual;

Result: 123