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
How to Reduce Operational Complexity with Enteros Database Optimization and Cloud Financial Intelligence
- 24 May 2026
- Database Performance Management
Introduction Modern enterprises are operating in increasingly complex digital environments driven by cloud computing, artificial intelligence, real-time analytics, distributed applications, and rapidly growing data ecosystems. Organizations across industries rely heavily on cloud-native platforms and database-driven applications to support scalability, operational agility, and customer experiences. Today’s technology ecosystems support: Cloud infrastructures SaaS applications AI and machine … Continue reading “How to Reduce Operational Complexity with Enteros Database Optimization and Cloud Financial Intelligence”
How to Improve Retail Cloud Efficiency with Enteros Database Software and Infrastructure Intelligence
Introduction The retail industry is rapidly transforming as organizations accelerate digital commerce initiatives, modernize customer engagement platforms, and expand cloud-based infrastructures. Retailers today operate highly connected ecosystems involving ecommerce platforms, supply chain systems, customer analytics applications, payment processing environments, and omnichannel retail experiences. Modern retail organizations rely heavily on cloud technologies to support: Ecommerce platforms … Continue reading “How to Improve Retail Cloud Efficiency with Enteros Database Software and Infrastructure Intelligence”
How AI-Driven Database Analytics Enhances Performance and Scalability in Modern Insurance Platforms
Introduction The insurance industry is undergoing rapid digital transformation. Modern insurance platforms now support a wide range of digital services, including online policy management, automated claims processing, customer self-service portals, fraud detection systems, and AI-powered risk analysis. As customer expectations continue to evolve, insurance providers must deliver faster, more personalized, and highly reliable digital experiences. … Continue reading “How AI-Driven Database Analytics Enhances Performance and Scalability in Modern Insurance Platforms”
How to Drive Intelligent Cloud Governance with Enteros Database Management Platform and AIOps
- 22 May 2026
- Database Performance Management
Introduction Cloud computing has become the foundation of modern digital transformation. Organizations across industries increasingly rely on cloud-native infrastructures, distributed applications, AI-driven services, and real-time analytics platforms to support innovation, scalability, and operational agility. Today’s enterprises operate highly complex cloud ecosystems that support: Business-critical applications Database environments Customer engagement platforms AI and machine learning workloads … Continue reading “How to Drive Intelligent Cloud Governance with Enteros Database Management Platform and AIOps”