Oracle CHR function

Preamble

The Oracle/PLSQL CHR function is the opposite of the ASCII function. CHR returns a character that is based on numeric code.

Syntax of the Oracle/PLSQL CHR function

CHR (number_code_id)

• number_code_id – number code used to extract a character.

The CHR function returns a string value.

CHR function in the following versions of Oracle/PLSQL

Let’s look at some examples of the CHR function and learn how to use the CHR function in Oracle/PLSQL.

SQL> SELECT CHR(114) FROM DUAL;
--Result: r

SQL> SELECT CHR(82) FROM DUAL;
--Result: R

SQL> SELECT CHR(37) FROM DUAL;
--Result: %

The Oracle CHR function allows users to provide a numeric code

About Enteros

​​​​Enteros offers a patented database performance management SaaS platform. It proactively identifies root causes of complex business-impacting database scalability and performance issues across a growing number of clouds, RDBMS, NoSQL, and machine learning database platforms.​