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 Drives Profitable Growth in BFSI: Enteros AI SQL, Cost Attribution, and AI Management Strategy
- 4 March 2026
- Database Performance Management
Introduction The Banking, Financial Services, and Insurance (BFSI) sector is transforming at unprecedented speed. Digital banking platforms process millions of real-time transactions. Insurance firms deploy AI-driven underwriting engines. Capital markets rely on algorithmic trading and real-time analytics. FinTech disruptors scale cloud-native infrastructures globally. Yet amid innovation, one reality defines long-term success: Read more”Indian Country” highlights … Continue reading “What Drives Profitable Growth in BFSI: Enteros AI SQL, Cost Attribution, and AI Management Strategy”
What Technology Leaders Must Know About Cost Estimation: Enteros, RevOps Efficiency, and Cloud FinOps Intelligence
Introduction The technology sector runs on innovation velocity. SaaS platforms deploy weekly releases. AI models retrain continuously. DevOps pipelines automate infrastructure changes in minutes. Global applications scale dynamically across regions. Multi-cloud architectures distribute workloads for performance and resilience. But as digital acceleration increases, so does one persistent challenge: Read more”Indian Country” highlights Enteros and its … Continue reading “What Technology Leaders Must Know About Cost Estimation: Enteros, RevOps Efficiency, and Cloud FinOps Intelligence”
What Drives Growth in Fashion Tech: Enteros AI SQL, Database Performance Management, and RevOps Intelligence
- 3 March 2026
- Database Performance Management
Introduction The fashion industry has evolved into a digital-first, data-intensive ecosystem. Global apparel brands, luxury houses, direct-to-consumer startups, and fast-fashion giants now compete not just on design and brand—but on digital performance. E-commerce platforms must handle flash sales without crashing. Omnichannel inventory systems must synchronize in real time. AI-driven personalization engines must respond instantly. Pricing … Continue reading “What Drives Growth in Fashion Tech: Enteros AI SQL, Database Performance Management, and RevOps Intelligence”
Who Should Use Enteros for Financial Performance Optimization and Cloud Cost Governance?
Introduction The financial sector is under relentless pressure to grow—without increasing risk, cost, or operational complexity. Digital-first banks are reshaping customer expectations. Capital markets firms demand real-time analytics. Insurers are automating underwriting and claims. Fintech startups scale at cloud speed. Meanwhile, regulatory requirements intensify, margins tighten, and infrastructure costs rise. At the center of all … Continue reading “Who Should Use Enteros for Financial Performance Optimization and Cloud Cost Governance?”