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
|
Oracle 12c, Oracle 11g, Oracle 10g, Oracle 9i, Oracle 8i
|
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.
The views expressed on this blog are those of the author and do not necessarily reflect the opinions of Enteros Inc. This blog may contain links to the content of third-party sites. By providing such links, Enteros Inc. does not adopt, guarantee, approve, or endorse the information, views, or products available on such sites.
Are you interested in writing for Enteros’ Blog? Please send us a pitch!
RELATED POSTS
What to Know About Enteros Cost Attribution and AI Performance Management for Media Sector Growth with Generative AI
- 7 April 2026
- Database Performance Management
Introduction The media sector is undergoing a massive transformation fueled by digital streaming, real-time content delivery, AI-driven personalization, and data-intensive production workflows. From OTT platforms and digital publishing to gaming and broadcasting, media companies are handling enormous volumes of data while striving to deliver seamless user experiences. However, with this rapid growth comes a pressing … Continue reading “What to Know About Enteros Cost Attribution and AI Performance Management for Media Sector Growth with Generative AI”
How to Transform Financial Sector Operations with Enteros Database Management Platform, AIOps, and Cloud FinOps
Introduction The financial sector is undergoing rapid digital transformation driven by mobile banking, real-time payments, algorithmic trading, and AI-powered services. Financial institutions must deliver seamless, secure, and high-performance digital experiences while managing rising infrastructure costs and strict regulatory requirements. At the center of this transformation lies a critical challenge:how to optimize database performance, control cloud … Continue reading “How to Transform Financial Sector Operations with Enteros Database Management Platform, AIOps, and Cloud FinOps”
How to Optimize Technology Sector Growth with Enteros Cost Estimation, Cloud FinOps, RevOps Efficiency, and AI SQL
- 6 April 2026
- Database Performance Management
Introduction The technology sector is evolving at an unprecedented pace, driven by cloud computing, SaaS platforms, AI innovation, and data-driven business models. Companies are scaling rapidly, deploying applications across multi-cloud environments, and handling massive volumes of data in real time. However, with this growth comes a critical challenge:how to scale efficiently while controlling costs, maintaining … Continue reading “How to Optimize Technology Sector Growth with Enteros Cost Estimation, Cloud FinOps, RevOps Efficiency, and AI SQL”
How to Transform Financial Sector Growth Management with Enteros Performance Management, AIOps Platform, and Generative AI
Introduction The financial sector is experiencing a profound transformation fueled by digital banking, real-time payments, algorithmic trading, and AI-driven customer experiences. Financial institutions are under immense pressure to deliver seamless services while maintaining regulatory compliance, managing risk, and optimizing operational costs. At the core of this transformation lies a critical challenge:how to scale growth while … Continue reading “How to Transform Financial Sector Growth Management with Enteros Performance Management, AIOps Platform, and Generative AI”