SQL NCHR() Function

SQL NCHR() Function return the DECIMAL value of the given ASCII argument (National character).

SQL NCHR() Function supported Oracle SQL version

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

Syntax

NCHR(number)

Example

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

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

NCHR
----
   J

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

NCHR
----
   E

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

NCHR
----
   M

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

NCHR JEM
--------
     JEM