Learn how to use the Oracle/PLSQL GREATEST function with syntax and examples.
The Oracle/PLSQL GREATEST function returns the greatest value in a list of expressions.
The syntax for the Oracle/PLSQL GREATEST function is:
GREATEST( expr1, expr2, ... expr_n )
expr1, expr2, . expr_n are expressions that are evaluated by the GREATEST function.
If the datatypes of the expressions are different, all expressions will be converted to whatever datatype expr1 is.
If the comparison is based on a character comparison, one character is considered greater than another if it has a higher character set value.
The GREATEST function can be used in the following versions of Oracle/PLSQL:
Let's look at some Oracle GREATEST function examples and explore how to use the GREATEST function in Oracle/PLSQL.
GREATEST(2, 5, 12, 3) Result: 12 GREATEST('2', '5', '12', '3') Result: '5' GREATEST('apples', 'oranges', 'bananas') Result: 'oranges' GREATEST('apples', 'applis', 'applas') Result: 'applis'