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
How Can Retail IT Teams Improve Database Capacity Planning for Peak Demand?
- 22 September 2026
- Database Performance Management
Retail IT teams can improve retail database capacity planning by analyzing historical workloads, monitoring SQL performance, tracking CPU, memory, storage, connections, and transaction growth, and forecasting future demand. Strong retail database performance management helps teams identify capacity risks before peak events, while Enteros supports proactive planning with observability, anomaly detection, predictive analytics, and workload intelligence. … Continue reading “How Can Retail IT Teams Improve Database Capacity Planning for Peak Demand?”
How Can Telecom Providers Improve Database Scalability for 5G and IoT Growth?
By integrating SQL optimisation, continuous observability, workload monitoring, anomaly detection, capacity planning, and effective cloud resource management, telecom operators can increase the scalability of telecom databases. Infrastructure that can manage quickly increasing device and transaction loads is necessary for robust database performance for 5G networks. Enteros assists telecom teams with capacity forecasting, bottleneck identification, and … Continue reading “How Can Telecom Providers Improve Database Scalability for 5G and IoT Growth?”
How Do Streaming Services Manage Database Bottlenecks For New Content Releases And Large Live Events?
Streaming platforms can monitor SQL workloads, query latency, transaction volume, resource usage, database waits, locking, and sudden workload changes to avoid database bottlenecks during major live events and content releases. Effective streaming database performance monitoring empowers IT teams to identify performance risks earlier, optimise inefficient queries, plan capacity, and deliver reliable user experiences in times … Continue reading “How Do Streaming Services Manage Database Bottlenecks For New Content Releases And Large Live Events?”
How Do Hospitals Stop Databases From Slowing Down At Emergency and High Patient Admission Times?
Hospitals can avoid database slowdowns during emergency and high-volume admission periods with continual monitoring of SQL workloads, transaction latency, database waits, locking, utilization of resources, connection levels and sudden workload changes. By effectively monitoring hospital database performance, healthcare IT teams can detect bottlenecks sooner, optimize inefficient queries, plan capacity, and maintain reliable access to vital … Continue reading “How Do Hospitals Stop Databases From Slowing Down At Emergency and High Patient Admission Times?”