SQL CHR() Function

SQL CHR() Function return the DECIMAL value of the given ASCII argument.

SQL CHR() Function supported Oracle SQL version

Oracle 8i
Oracle 9i
Oracle 10g
Oracle 11g
Oracle 12c
Oracle 18c

Syntax

CHR(number)

Example

Consider following example return the decimal value of given ASCII argument.

SQL> SELECT CHR(74) "CHR" FROM DUAL;

CHR
---
  J

SQL> SELECT CHR(69) "CHR" FROM DUAL;

CHR
---
  E

SQL> SELECT CHR(77) "CHR" FROM DUAL;

CHR
---
  M

SQL> SELECT CHR(74)||CHR(69)||CHR(77) "CHR JEM" FROM DUAL;

CHR JEM
-------
    JEM