Preamble
The Oracle/PLSQL INITCAP function sets the first character of each word in upper case, and the rest in lower case.
Syntax of the Oracle/PLSQL INITCAP function
INITCAP( string1_id )
Parameters and function arguments
- string1_id – is an argument string, the first character in each word will be uppercase, and all other characters will be uppercase.
The INITCAP function returns a string value.
The INITCAP function can be used in the following versions of Oracle/PLSQL
|
Oracle 12c, Oracle 11g, Oracle 10g, Oracle 9i, Oracle 8i
|
Let’s consider some examples of the INITCAP function and learn how to use the INITCAP function in Oracle/PLSQL.
SQL> SELECT INITCAP FROM DUAL ('shop of antiquities');
--Result: An antiquities shop
SQL> SELECT INITCAP('CHARLES DICKENS') FROM DUAL;
--Result: Charles Dickens
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 Optimize Insurance Operations with Enteros Database Software, AI-Powered Analytics, and Database Observability
- 11 August 2026
- Database Performance Management
Introduction Insurance companies manage enormous volumes of policy, claims, underwriting, customer, actuarial, billing, and regulatory data. Their technology environments must support millions of transactions while delivering fast digital experiences to policyholders, agents, brokers, and employees. Database performance directly influences claims processing, policy administration, underwriting, customer service, billing, and reporting. Enteros helps insurance organizations optimize these … Continue reading “How to Optimize Insurance Operations with Enteros Database Software, AI-Powered Analytics, and Database Observability”
How to Optimize Banking Operations with Enteros Database Software, AI-Powered Analytics, and Database Observability
Introduction Banking organizations depend on databases for virtually every critical transaction. Account management, payments, lending, fraud detection, online banking, credit processing, wealth management, and regulatory reporting all require reliable and high-performing database infrastructure. As financial institutions modernize through cloud computing, AI, digital banking, open banking, and real-time payments, database environments are becoming increasingly complex. Enteros … Continue reading “How to Optimize Banking Operations with Enteros Database Software, AI-Powered Analytics, and Database Observability”
How AIOps and FinOps Improve Cloud Performance and Cost Management in BFSI
Introduction The Banking, Financial Services, and Insurance (BFSI) industry is undergoing rapid digital transformation. Mobile banking, digital payments, online lending, insurance platforms, wealth management applications, fraud detection systems, and real-time financial services increasingly depend on cloud infrastructure to deliver fast, reliable, and scalable experiences. However, cloud adoption also introduces new operational and financial challenges. BFSI … Continue reading “How AIOps and FinOps Improve Cloud Performance and Cost Management in BFSI”
How AIOps and FinOps Drive Cost-Efficient Digital Transformation in Banking
- 9 August 2026
- Database Performance Management
Introduction Digital transformation has become a strategic priority for banks and financial institutions. From mobile banking and digital payments to real-time fraud detection, personalized financial services, and cloud-native applications, banking organizations are investing heavily in technology to deliver faster, smarter, and more convenient customer experiences. However, digital transformation also introduces a major challenge: how can … Continue reading “How AIOps and FinOps Drive Cost-Efficient Digital Transformation in Banking”