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
From Cloud Costs to Competitive Advantage: AI-Driven Retail Growth with Enteros
- 6 January 2026
- Database Performance Management
Introduction The retail industry is operating in one of the most competitive and digitally complex environments in its history. Omnichannel commerce, real-time inventory visibility, personalized customer journeys, AI-driven recommendations, dynamic pricing engines, and always-on digital storefronts have become table stakes for modern retailers. Behind every seamless customer experience lies a massive and ever-expanding technology backbone—cloud … Continue reading “From Cloud Costs to Competitive Advantage: AI-Driven Retail Growth with Enteros”
AI-Driven Performance Management Across Financial and Retail Platforms with Enteros
Introduction Financial services and retail enterprises are operating at the center of the digital economy. Real-time payments, mobile banking, eCommerce transactions, omnichannel retail, loyalty platforms, fraud detection, personalization engines, and digital marketplaces all rely on complex, always-on technology ecosystems. While the business models of financial institutions and retailers differ, their technology challenges are increasingly similar. … Continue reading “AI-Driven Performance Management Across Financial and Retail Platforms with Enteros”
Improving Patient Access While Controlling Digital Costs: Enteros’ Website Optimization Platform for Healthcare
- 5 January 2026
- Database Performance Management
Introduction Healthcare delivery has become deeply digital. From hospital websites and patient portals to telehealth platforms, appointment scheduling systems, online billing, and digital front doors, healthcare organizations increasingly rely on web-based experiences to connect patients with care. For patients, these digital touchpoints are no longer optional—they are essential. Patients expect fast-loading websites, seamless navigation, secure … Continue reading “Improving Patient Access While Controlling Digital Costs: Enteros’ Website Optimization Platform for Healthcare”
The New Economics of Entertainment Platforms: Enteros’ Cloud FinOps and AIOps-Driven Database Optimization
Introduction The entertainment industry is experiencing a profound digital transformation. Streaming platforms, OTT services, gaming ecosystems, live events, digital content marketplaces, and immersive experiences now operate on massive, always-on technology infrastructures. Millions of users expect seamless playback, real-time interaction, personalized recommendations, and uninterrupted access—regardless of geography or device. Behind every stream, game session, recommendation, and … Continue reading “The New Economics of Entertainment Platforms: Enteros’ Cloud FinOps and AIOps-Driven Database Optimization”