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