Preamble
Oracle/PLSQL GREATEST function returns the highest value in the list of expressions.
Oracle/PLSQL syntax of the GREATEST function
GREATEST( expr1_id, expr2_id, ... expr_n_id )
Parameters and function arguments
- expr1_id, expr2_id, … expr_n_id – expressions the largest value of which is defined by the GREATEST function.
The GREATEST function returns the value of the same data type as expr1.
The GREATEST 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 GREATEST function and learn how to use the GREATEST function in Oracle/PLSQL.
SELECT GREATEST(2, 5, 12, 3) FROM DUAL;
--Result: 12
SELECT GREATEST('2', '5', '12', '3') FROM DUAL;
--Result: 5
SELECT GREATEST('apples', 'oranges', 'bananas') FROM DUAL;
--Result: oranges
SELECT GREATEST('apples', 'applis', 'applas') FROM DUAL;
--Result: applis
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
Enteros for Insurance: Redefining AI Performance, Data Lake Management, and Cloud FinOps Excellence
- 7 October 2025
- Database Performance Management
Introduction The insurance industry stands at the crossroads of transformation — where data-driven insights, artificial intelligence (AI), and cloud technologies are reshaping business operations. Today’s insurers operate in a digital-first world, collecting and analyzing enormous volumes of data from multiple channels — customer interactions, policy applications, claims, IoT devices, and third-party providers. This explosion of … Continue reading “Enteros for Insurance: Redefining AI Performance, Data Lake Management, and Cloud FinOps Excellence”
Revolutionizing Healthcare IT: How Enteros AIOps and Observability Platforms Are Transforming Database Performance Management
Introduction In today’s data-driven healthcare landscape, precision, speed, and reliability are paramount. From real-time patient monitoring and electronic health records (EHRs) to AI-assisted diagnostics and predictive analytics, healthcare organizations rely on massive databases and complex IT infrastructures to deliver life-saving insights and services. However, as data volumes surge and systems become more distributed, managing database … Continue reading “Revolutionizing Healthcare IT: How Enteros AIOps and Observability Platforms Are Transforming Database Performance Management”
From Data to Delivery: How Enteros Transforms D2C Brands Through Database Performance and Cloud FinOps
- 6 October 2025
- Database Performance Management
Introduction In the fast-evolving world of Direct-to-Consumer (D2C) brands, agility and performance are everything. D2C businesses thrive on personalization, speed, and customer trust — all of which depend on how efficiently data flows through their systems. Behind every product recommendation, every smooth checkout, and every on-time delivery is a complex network of databases, cloud infrastructure, … Continue reading “From Data to Delivery: How Enteros Transforms D2C Brands Through Database Performance and Cloud FinOps”
How Enteros AI Performance and Data Lake Optimization Are Powering Innovation in the Fashion Industry
Introduction The fashion industry, once ruled by instinct and creativity alone, is now undergoing a seismic transformation driven by data and artificial intelligence (AI). From forecasting trends to managing supply chains and customer experiences, data-driven insights are redefining how fashion brands operate. Central to this digital shift is the use of AI-driven performance management and … Continue reading “How Enteros AI Performance and Data Lake Optimization Are Powering Innovation in the Fashion Industry”