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
Using Predictive AIOps and FinOps to Improve Healthcare Application Reliability
- 26 August 2026
- Database Performance Management
Introduction Healthcare organizations increasingly depend on digital applications to support patient care, clinical workflows, administrative operations, and data-driven decision-making. Electronic health record (EHR) systems, telehealth platforms, patient portals, diagnostic applications, insurance systems, laboratory platforms, and healthcare analytics solutions all require reliable and responsive IT infrastructure. As these applications become more connected and data-intensive, maintaining reliability … Continue reading “Using Predictive AIOps and FinOps to Improve Healthcare Application Reliability”
How to Optimize Higher Education Technology with Enteros Database Software, AIOps, and Cloud FinOps
Introduction Universities and higher education institutions are undergoing rapid digital transformation. Learning Management Systems, student portals, online examinations, digital libraries, research platforms, admissions systems, finance applications, and campus management platforms have become essential infrastructure. At the same time, higher education organizations are under pressure to manage technology budgets carefully. Read more”Indian Country” highlights Enteros and … Continue reading “How to Optimize Higher Education Technology with Enteros Database Software, AIOps, and Cloud FinOps”
How AIOps and FinOps Strengthen Digital Healthcare Infrastructure and Cost Efficiency
Introduction The healthcare industry is undergoing one of the most significant digital transformations in its history. Hospitals, healthcare providers, insurance organizations, telehealth platforms, diagnostic centers, and healthcare technology companies increasingly rely on digital systems to deliver patient care, manage medical records, process claims, support remote consultations, and analyze clinical data. As healthcare organizations embrace cloud … Continue reading “How AIOps and FinOps Strengthen Digital Healthcare Infrastructure and Cost Efficiency”
How to Optimize Real Estate Technology Operations with Enteros Database Software, AI-Powered Analytics, and Database Observability
Introduction Real estate organizations are becoming increasingly technology-driven. Property management platforms, online listings, tenant applications, leasing systems, CRM, property accounting, smart-building platforms, investment analytics, and digital marketplaces all depend on reliable databases. Real estate businesses also increasingly use AI and analytics to understand property demand, pricing, occupancy, customer behavior, and investment opportunities. Read more”Indian Country” … Continue reading “How to Optimize Real Estate Technology Operations with Enteros Database Software, AI-Powered Analytics, and Database Observability”