Preamble
The Oracle/PLSQL LOWER function converts all characters in a specified string into lower case. If there are characters in the string that are not letters, they do not affect this function.
Syntax of the Oracle/PLSQL LOWER function
LOWER( string1_id )
Parameters and function arguments
- string1_id – string for lowercase conversion.
The LOWER function returns a string value.
The LOWER 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 LOWER function and learn how to use the LOWER function in Oracle PLSQL.
SQL> SELECT LOWER('Charles Dickens') FROM DUAL;
-result: charles dickens
SQL> SELECT LOWER('CHARLES DICKENS 1812 - 1870 ') FROM DUAL;
-result: charles dickens 1812 - 1870 '
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 Consider for Telecom RevOps with Enteros Cost Estimation, AI SQL, and Cloud FinOps Platform
- 26 March 2026
- Database Performance Management
Introduction The telecommunications sector is experiencing a massive transformation driven by 5G deployment, IoT expansion, edge computing, and data-intensive digital services. Telecom operators are no longer just connectivity providers—they are becoming digital service platforms supporting streaming, enterprise solutions, and real-time applications. As telecom companies scale to meet increasing demand, they face a fundamental challenge: How … Continue reading “What to Consider for Telecom RevOps with Enteros Cost Estimation, AI SQL, and Cloud FinOps Platform”
What to Consider for Growth Management in the Financial Sector with Enteros Cost Estimation and Attribution
Introduction The financial sector is undergoing a rapid transformation fueled by digital banking, real-time payments, AI-driven risk analysis, and data-intensive customer experiences. From global banks to fintech startups, organizations are investing heavily in technology to remain competitive and deliver seamless services. However, as financial institutions scale their digital operations, a critical challenge emerges: How can … Continue reading “What to Consider for Growth Management in the Financial Sector with Enteros Cost Estimation and Attribution”
What to Consider for Growth Management with Enteros Software Performance and AIOps Platform in Tech
- 25 March 2026
- Database Performance Management
Introduction The technology sector is at the forefront of global innovation, powering everything from cloud computing and SaaS platforms to artificial intelligence and real-time digital services. As technology companies scale rapidly, they face increasing pressure to deliver high-performance applications, maintain reliability, and optimize operational costs—all while driving continuous growth. At the core of this challenge … Continue reading “What to Consider for Growth Management with Enteros Software Performance and AIOps Platform in Tech”
How Enteros Database Performance Management Transforms Manufacturing RevOps and Operational Efficiency
Introduction The manufacturing sector is undergoing a rapid digital evolution driven by smart factories, Industrial IoT (IIoT), predictive maintenance, and real-time supply chain optimization. Modern manufacturers rely heavily on data to streamline operations, improve product quality, and respond quickly to market demands. At the core of this transformation lies a complex IT ecosystem powered by … Continue reading “How Enteros Database Performance Management Transforms Manufacturing RevOps and Operational Efficiency”